Re: Quality and Performance - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Quality and Performance
Date
Msg-id 20071127123606.65a6ab04@commandprompt.com
Whole thread Raw
In response to Re: Quality and Performance  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Quality and Performance  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 27 Nov 2007 20:32:57 +0000
Simon Riggs <simon@2ndquadrant.com> wrote:

> On Tue, 2007-11-27 at 13:54 -0500, Tom Lane wrote:
> 
> > However, I think everybody agrees that getting blindsided by
> > unexpected performance dropoffs is a bad thing.  We really need to
> > reinstitute the sort of daily (or near-daily) performance tracking
> > that Mark Wong used to be doing, and extend it to cover a wider
> > variety of test cases than just DBT-2.  As an example, I'll bet
> > that this issue of operator lookup speed would never have been
> > visible at all in DBT-2.
> 
> Yeh, we need multiple large benchmarks run on a regular basis.
> 
> My understanding is the community has two 8-core servers to run
> benchmarks on, but I'd quite like to have some details on where these
> are at. One is likely to be running RHEL, one Solaris.

The RHEL one as I know it, is the MyYearbook donated one. We are
currently unaware of the status of that machine except to say it is
currently running Gentoo.

I don't know the status of the Solaris machine except that I think we
had IO issues with it.

Sincerely,

Joshua D. Drake


> 
> We also need performance regression tests, which is a slightly
> different thing even if they do sound similar.
> 


- -- 
     === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/        UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHTH+7ATb/zqfZUUQRAhlYAJ0QqG5CzDmQfi2ynj/i9xJoe1nWUACeOyJQ
gSOnZhVhp61HbOlfRjfDzvM=
=MEIW
-----END PGP SIGNATURE-----

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Quality and Performance
Next
From: Tom Lane
Date:
Subject: Re: PG 7.3 is five years old today