Re: Quality and Performance

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Quality and Performance
Date: 2007-11-27 18:04:56
Message-ID: 20071127180456.GC11978@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Nov 27, 2007 at 05:32:49PM +0000, Simon Riggs wrote:
> What I would really like to persuade everybody is that performance needs
> specific attention.

[. . .]

> Your thoughts are welcome,

Well, one thing that might help is something of the specifics you mention.

I remember mentioning to Jan not long after he started at Afilias that we
occasionally saw strange behaviour that looked like "lock up". He was
slightly incredulous, and I didn't have time to build a repeatable test
case. So it was in the context of testing Slony that he discovered the dual
pains of buffer shuffling and checkpoint storms; this is part of what led
him to work on those problems in 8.0.

The key was to state, at the outset, "Here is the problem I want to fix."
By stating precisely and specifically what is to be fixed, the issue moves
from "performance needs" to a feature that can be implemented.

Perhaps now is the time to list some specific performance areas you want to
fix up?

A

--
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2007-11-27 18:08:22 Re: Quality and Performance
Previous Message Peter Eisentraut 2007-11-27 18:04:08 Re: psql -f doesn't complain about directories