Tom Lane wrote: > Jan de Visser <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
