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: 417977EE.8050207@zeut.net (view raw or flat)
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
>tables?  
>
Yes that is the long term goal, but the autovac in 8.0 is still all or 
nothing.

In response to

Responses

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-2014 The PostgreSQL Global Development Group