Hello,

Just wanted to share some data I've generated with dbt-2 using
tablespaces from a CVS export of PostgreSQL on June 22.  I have results
and details on how I have the disks laid out with LVM2 here:
	http://www.osdl.org/projects/dbt2dev/results/dev4-006/538/

The performance appears to be on par with results I've been getting with
PostgreSQL 7.4.1.  For a comparison, you can see those results here:
	http://www.osdl.org/projects/dbt2dev/results/dev4-006/526/

The volume where the database log resides is identicle between the two
tests.  The disk layout has only changed for where the tables and
indexes reside.

-- 
Mark Wong - - markw@osdl.org
Open Source Development Lab Inc - A non-profit corporation
12725 SW Millikan Way - Suite 400 - Beaverton, OR 97005
(503) 626-2455 x 32 (office)
(503) 626-2436      (fax)
http://developer.osdl.org/markw/

Wed, 23 Jun 2004 14:24:54 -0700 (PDT)
markw@osdl.org
DBT-2 results using tablespaces
Your response times improved across the board over 7.4.1..  Is that
change significant, or within the variation you see on your system?

On Wed, 2004-06-23 at 14:24, markw@osdl.org wrote:
> Hello,
> 
> Just wanted to share some data I've generated with dbt-2 using
> tablespaces from a CVS export of PostgreSQL on June 22.  I have results
> and details on how I have the disks laid out with LVM2 here:
> 	http://www.osdl.org/projects/dbt2dev/results/dev4-006/538/
> 
> The performance appears to be on par with results I've been getting with
> PostgreSQL 7.4.1.  For a comparison, you can see those results here:
> 	http://www.osdl.org/projects/dbt2dev/results/dev4-006/526/
> 
> The volume where the database log resides is identicle between the two
> tests.  The disk layout has only changed for where the tables and
> indexes reside.
-- 
Mary Edie Meredith 
maryedie@osdl.org
503-626-2455 x42
Open Source Development Labs


Thu, 24 Jun 2004 10:34:03 -0700
Mary Edie Meredith <maryedie@osdl.org>
Re: DBT-2 results using tablespaces