Re: DBT-2 results using tablespaces

From: Mary Edie Meredith <maryedie(at)osdl(dot)org>
To: Mark Wong <markw(at)osdl(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: DBT-2 results using tablespaces
Date: 2004-06-24 17:34:03
Message-ID: 1088098443.2934.47.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)osdl(dot)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(at)osdl(dot)org
503-626-2455 x42
Open Source Development Labs

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2004-06-24 18:40:58 Re: warning missing
Previous Message Tom Lane 2004-06-24 17:29:13 Re: bug in GUC