Re: Quality and Performance - Mailing list pgsql-hackers

From Andrew Sullivan
Subject Re: Quality and Performance
Date
Msg-id 20071127180456.GC11978@crankycanuck.ca
Whole thread Raw
In response to Quality and Performance  (Simon Riggs <simon@2ndquadrant.com>)
List 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


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: psql -f doesn't complain about directories
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Quality and Performance