X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id ACFD19F931E
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon,  8 May 2006 14:06:11 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 55713-08
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon,  8 May 2006 14:06:06 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2])
	by postgresql.org (Postfix) with ESMTP id 69BA39F931D
	for <pgsql-performance@postgresql.org>;
	Mon,  8 May 2006 14:06:06 -0300 (ADT)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
	id 7E5A831509; Mon,  8 May 2006 19:06:05 +0200 (MET DST)
From: "Andrus" <eetasoft@online.ee>
X-Newsgroups: pgsql.performance
Subject: Re: Query runs 38 seconds for small database!
Date: Mon, 8 May 2006 20:03:38 +0300
Organization: Hub.Org Networking Services
Lines: 11
Message-ID: <e3ntpp$qqg$1@news.hub.org>
References: <e3n8at$1f7i$1@news.hub.org> <26838.1147099614@sss.pgh.pa.us>
	<e3nqv9$30v0$1@news.hub.org> <27599.1147105626@sss.pgh.pa.us>
X-Complaints-To: usenet@news.hub.org
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
To: pgsql-performance@postgresql.org
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200605/136
X-Sequence-Number: 18923

> The default autovac thresholds are not very aggressive; this table was
> probably not large enough to get selected for analysis.

Tom,

thank you.
Excellent.

Andrus.