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
Date: Mon, 4 Jun 2007 14:08:13 -0400
Message-ID: <20070604180813.GR4779@alvh.no-ip.org> (raw)
In-Reply-To: <200706041305.12740.doug@hunley.homeip.net>
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>
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.
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, doug@hunley.homeip.net
Subject: Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
In-Reply-To: <20070604180813.GR4779@alvh.no-ip.org>
* 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