Re: Query runs 38 seconds for small database!

Tom Lane wrote:
> Jan de Visser <jdevisser(at)digitalfairway(dot)com> 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