Tom Lane wrote: > Jan de Visser <jdevisser@xxxxxxxxxxxxxxxxxx> writes: > > On Monday 08 May 2006 14:10, Andrus wrote: > >> I created empty table konto and loaded more that 219 records to it during > >> database creation. > >> So it seems that if table grows from zero to more than 219 times larger > >> then it was still not processed. > > > That's because you need at least 500 rows for analyze and 100 for a vacuum, > > (autovacuum_vacuum_threshold = 1000, autovacuum_analyze_threshold = 500). > > This crystallizes something that's been bothering me for awhile, > actually: why do the "threshold" variables exist at all? Matthew would know about that -- he invented them. I take no responsability :-) -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
