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

Re: Performance Anomalies in 7.4.5

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
Cc: PgSQL - Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance Anomalies in 7.4.5
Date: 2004-10-22 21:13:18
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
Andrew Sullivan wrote:

>>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
Yes that is the long term goal, but the autovac in 8.0 is still all or 

In response to


pgsql-performance by date

Next:From: Simon RiggsDate: 2004-10-22 22:01:05
Subject: Re: [PATCHES] ARC Memory Usage analysis
Previous:From: Manfred SpraulDate: 2004-10-22 20:55:38
Subject: Re: futex results with dbt-3

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