From: Alvaro Herrera <alvherre@commandprompt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jan de Visser <jdevisser@digitalfairway.com>
Cc: pgsql-performance@postgresql.org, "Matthew T. O'Connor" <matthew@zeut.net>
Subject: Re: Query runs 38 seconds for small database!
Date: Mon, 8 May 2006 16:02:59 -0400
Message-ID: <20060508200258.GJ3351@surnet.cl> (raw)
In-Reply-To: <29126.1147117718@sss.pgh.pa.us>
References: <e3n8at$1f7i$1@news.hub.org>
<20060508174604.GX99570@pervasive.com>
<e3o1ib$1ik3$1@news.hub.org>
<200605081519.39293.jdevisser@digitalfairway.com>
<29126.1147117718@sss.pgh.pa.us>
Tom Lane wrote:
> Jan de Visser <jdevisser@digitalfairway.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvherre@commandprompt.com, tgl@sss.pgh.pa.us, jdevisser@digitalfairway.com, matthew@zeut.net
Subject: Re: Query runs 38 seconds for small database!
In-Reply-To: <20060508200258.GJ3351@surnet.cl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox