pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: PgSQL - Performance <pgsql-performance@postgresql.org>
Subject: Re: Performance Anomalies in 7.4.5
Date: Mon, 25 Oct 2004 09:51:31 -0400
Message-ID: <20041025135131.GA2886@phlogiston.dyndns.org> (raw)
In-Reply-To: <417977EE.8050207@zeut.net>
References: <D307B888-23A0-11D9-8068-000D93AE0944@sitening.com>
	<25228.1098395599@sss.pgh.pa.us>
	<20041022194058.GC22395@phlogiston.dyndns.org>
	<417977EE.8050207@zeut.net>

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.

A 

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The plural of anecdote is not data.
		--Roger Brinner



view thread (15+ messages)  latest in thread

Message-ID: <20041025135131.GA2886@phlogiston.dyndns.org>
Permalink:  ../20041025135131.GA2886@phlogiston.dyndns.org/
Also on:    postgresql.org/message-id/20041025135131.GA2886@phlogiston.dyndns.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: ajs@crankycanuck.ca
  Subject: Re: Performance Anomalies in 7.4.5
  In-Reply-To: <20041025135131.GA2886@phlogiston.dyndns.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox