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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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