Re: Quality and Performance

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Quality and Performance
Date: 2007-11-27 20:36:06
Message-ID: 20071127123606.65a6ab04@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 27 Nov 2007 20:32:57 +0000
Simon Riggs <simon(at)2ndquadrant(dot)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-----

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-11-27 20:37:04 Re: PG 7.3 is five years old today
Previous Message Simon Riggs 2007-11-27 20:32:57 Re: Quality and Performance