Thread: DBT-2 results using tablespaces
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/
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