On Sat, Feb 25, 2006 at 08:15:15AM +, Robin Iddon wrote:
> From README.pg_autovacuum (and I think 22.1.4 of the 8.1.x document
> says the same thing):
>
> - If the number of (deletes + updates) > VacuumThreshold, then a
> vacuum analyze is performed.
>
> VacuumThreshold is equal to:
>va
You need 100k pages minimum here.
I don't actually understand exactly what this is telling me though!
Take a look at
http://www.pervasivepostgres.com/lp/newsletters/2005/Insights_opensource_Nov.asp#3
It's a good overview of the FSM, how it works, and how to understand
vacuum verbose
