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 4A2359FB205
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue,  2 May 2006 14:16:26 -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 19239-04-2
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue,  2 May 2006 14:16:04 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.logix-tt.com (unknown [212.211.145.186])
	by postgresql.org (Postfix) with ESMTP id 46F1C9FB204
	for <pgsql-performance@postgresql.org>;
	Tue,  2 May 2006 14:16:02 -0300 (ADT)
Received: from kingfisher.intern.logix-tt.com (Tb807.t.pppool.de
 [89.55.184.7])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.logix-tt.com (Postfix) with ESMTP id 2EBAE65800;
	Tue,  2 May 2006 19:17:06 +0200 (CEST)
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by kingfisher.intern.logix-tt.com (Postfix) with ESMTP id 3B8A7184C9BDD;
	Tue,  2 May 2006 19:16:12 +0200 (CEST)
Message-ID: <445793DC.40401@logix-tt.com>
Date: Tue, 02 May 2006 19:16:12 +0200
From: Markus Schaber <schabi@logix-tt.com>
Organization: Logical Tracking and Tracing International AG, Switzerland
User-Agent: Debian Thunderbird 1.0.7 (X11/20051017)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Bill Moran <wmoran@collaborativefusion.com>
Cc: Bealach-na Bo <bealach_na_bo@hotmail.com>, ahodgson@simkin.ca,
	pgsql-performance@postgresql.org
Subject: Re: Why so slow?
References: <200604281043.16083@hal.medialogik.com>
	<BAY101-F38A0FADC87E67C062FE5E1ADB00@phx.gbl>
	<20060430100346.20f010a9.wmoran@collaborativefusion.com>
In-Reply-To: <20060430100346.20f010a9.wmoran@collaborativefusion.com>
X-Enigmail-Version: 0.93.0.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200605/29
X-Sequence-Number: 18816

Hi, Bill,

Bill Moran wrote:

> My understanding is basically that if you vacuum with the correct
> frequency, you'll never need to vacuum full.  This is why the
> autovacuum system is so nice, it adjusts the frequency of vacuum according
> to how much use the DB is getting.

Additonally, the "free_space_map" setting has to be high enough, it has
to cover enough space to put in all pages that get dead rows between two
vacuum runs.

HTH,
Markus


-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org