Date: Mon, 4 Jun 2007 14:08:13 -0400
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Douglas J Hunley <doug@hunley.homeip.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
Message-ID: <20070604180813.GR4779@alvh.no-ip.org>
References: <200706020913.32241.doug@hunley.homeip.net>
	<200706031324.15605.doug@hunley.homeip.net>
	<Pine.GSO.4.64.0706031755370.7604@westnet.com>
	<200706041305.12740.doug@hunley.homeip.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <200706041305.12740.doug@hunley.homeip.net>
User-Agent: Mutt/1.5.13 (2006-08-11)

Douglas J Hunley wrote:

> On a side note, is there any real benefit to using autovacuum over a 
> periodically scheduled vacuum? I ask because we have the latter already coded 
> up and cron'd and it seems to keep things fairly optimized.

No, not really.  Maybe autovacuum could get to specific highly-updated
tables quickier than the cron job, or slow down when there's no
activity; but your current setup is good enough for you there's no
reason to change.

> BTW, I'm on the list, so there's no need to reply direct. I can get the 
> replies from the list

Huh, sorry, this is just the customary way to use these lists.
Personally, I prefer to get several copies of each message and have my
software (procmail) deliver only one to me discarding the duplicates.
That way, if one is lost or takes long to get home, I don't even notice
it (it used to happen a lot on the lists).  Look at the "eliminatecc"
option in the Majordomo user web pages.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.