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 Heng||Date: 2008-01-31 02:11:19|
|Subject: Re: postgresql book - practical or something newer?|
|Previous:||From: Swaminathan Saikumar||Date: 2008-01-31 01:12:27|
|Subject: Re: Is PostGreSql's Data storage mechanism "inferior"?|