Skip site navigation (1) Skip section navigation (2)

Re: Performance Anomalies in 7.4.5

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: PgSQL - Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance Anomalies in 7.4.5
Date: 2004-10-25 13:51:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Fri, Oct 22, 2004 at 05:13:18PM -0400, Matthew T. O'Connor wrote:

> Yes that is the long term goal, but the autovac in 8.0 is still all or 
> nothing.

Yes, which is why I couldn't use the current iteration for
production: the cost is too high.  I think this re-inforces my
original point, which is that taking away the ability of DBAs to
thump the planner for certain tables -- even indirectly -- under
certain pathological conditions is crucial for production work.  In
the ideal world, the wizards and genius planners and such like would
work perfectly, and the DBA would never have to intervene.  In
practice, there are cases when you need to haul on a knob or two. 
While this doesn't mean that we should adopt the Oracle approach of
having knobs which adjust the sensitivity of the knob that tunes the
main knob-tuner, I'm still pretty leery of anything which smacks of
completely locking the DBA's knowledge out of the system.


Andrew Sullivan  | ajs(at)crankycanuck(dot)ca
The plural of anecdote is not data.
		--Roger Brinner

In response to

pgsql-performance by date

Next:From: John MeinelDate: 2004-10-25 14:33:38
Subject: Re: Sequential Scan with LIMIT
Previous:From: Neil ConwayDate: 2004-10-25 07:24:54
Subject: Re: Sequential Scan with LIMIT

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group