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: Fri, 22 Oct 2004 15:40:58 -0400
Message-ID: <20041022194058.GC22395@phlogiston.dyndns.org> (raw)
In-Reply-To: <25228.1098395599@sss.pgh.pa.us>
References: <D307B888-23A0-11D9-8068-000D93AE0944@sitening.com>
	<25228.1098395599@sss.pgh.pa.us>


> Probably the most severe objection to doing things this way is that the
> selected plan could change unexpectedly as a result of the physical
> table size changing.  Right now the DBA can keep tight rein on actions
> that might affect plan selection (ie, VACUUM and ANALYZE), but that
> would go by the board with this.  OTOH, we seem to be moving towards
> autovacuum, which also takes away any guarantees in this department.

But aren't we requiring that we can disable autovacuum on some
tables?  I've actually used, more than once, the finger-on-the-scale
method of thumping values in pg_class when I had a pretty good idea
of how the table was changing, particularly when it would change in
such a way as to confuse the planner.  There are still enough cases
where the planner doesn't quite get things right that I'd really
prefer the ability to give it clues, at least indirectly.  I can't
imagine that there's going to be a lot of enthusiasm for hints, so
anything that isn't a sure-fire planner helper is a potential loss,
at least to me.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
I remember when computers were frustrating because they *did* exactly what 
you told them to.  That actually seems sort of quaint now.
		--J.D. Baldwin



view thread (15+ messages)  latest in thread

Message-ID: <20041022194058.GC22395@phlogiston.dyndns.org>
Permalink:  ../20041022194058.GC22395@phlogiston.dyndns.org/
Also on:    postgresql.org/message-id/20041022194058.GC22395@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: <20041022194058.GC22395@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