From: Vinubalaji Gopal <vgopal@abaca.com>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Pgsql-Performance ((E-mail)) <pgsql-performance@postgresql.org>
Subject: Re: best way to run maintenance script
Date: Fri, 14 Mar 2008 17:51:52 -0800
Message-ID: <1205545912.12661.22.camel@vinu-ubuntu.abaca> (raw)
In-Reply-To: <20080314173235.58f854e6@commandprompt.com>
References: <1205542821.12661.16.camel@vinu-ubuntu.abaca>
<20080314173235.58f854e6@commandprompt.com>
Hi Joshua,
> You can use parameters such as vacuum_cost_delay to help this... see
> the docs:
>
> http://www.postgresql.org/docs/8.3/static/runtime-config-autovacuum.html
I am checking it out. Seems to be a nice option for vacuum - but wish
there was a way to change the delete priority or I will try to use the C
based priority hack.
> If you are truly running 8.0 and not something like 8.0.15 vacuum is
> the least of your worries.
Its 8.0.4.
Thanks.
--
Vinu
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: vgopal@abaca.com, jd@commandprompt.com
Subject: Re: best way to run maintenance script
In-Reply-To: <1205545912.12661.22.camel@vinu-ubuntu.abaca>
* 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