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

Re: enabling autovacuum

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Jeremy Harris <jgh(at)wizmail(dot)org>
Cc: Chander Ganesan <chander(at)otg-nc(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: enabling autovacuum
Date: 2008-01-31 01:56:39
Message-ID: 47A12AD7.7090004@zeut.net (view raw or flat)
Thread:
Lists: pgsql-general
Jeremy Harris wrote:
> Chander Ganesan wrote:
>> Inserts don't generate dead tuples, and AVD looks at obsolete 
>> tuples..  As such,  I wouldn't expect AVD to kick off until after you 
>> did a mass delete...assuming that delete was sizable enough to 
>> trigger a vacuum.
>
> Ah, that would explain it - thankyou.   So I need to retreat to
> the question of why the weekly vacuum permits the observed bloat.
> Any ideas?   More information that I could gather? 

Autovacuum will kick off an analyze if you do enough inserts however.


In response to

pgsql-general by date

Next:From: Ow Mun HengDate: 2008-01-31 02:11:19
Subject: Re: postgresql book - practical or something newer?
Previous:From: Swaminathan SaikumarDate: 2008-01-31 01:12:27
Subject: Re: Is PostGreSql's Data storage mechanism "inferior"?

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