Re: Autovacuum / full vacuum

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Michael Riess <mlriess(at)gmx(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum / full vacuum
Date: 2006-01-17 14:09:02
Message-ID: 43CCFA7E.1060307@zeut.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Michael Riess wrote:
> did you read my post? In the first part I explained why I don't want to
> increase the FSM that much.

I'm sure he did, but just because you don't have enough FSM space to
capture all everything from your "burst", that doesn't mean that space
can't be reclaimed. The next time a regular vacuum is run, it will once
again try to fill the FSM with any remaining free space it finds in the
table. What normally happens is that your table will never bee 100%
free of dead space, normally it will settle at some steady state size
that is small percentage bigger than the table will be after a full
vacuum. As long as that percentage is small enough, the effect on
performance is negligible. Have you measured to see if things are truly
faster after a VACUUM FULL?

Matt

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Markus Schaber 2006-01-17 14:30:14 Re: Autovacuum / full vacuum
Previous Message Michael Riess 2006-01-17 14:05:29 Re: Autovacuum / full vacuum