pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Vinubalaji Gopal <vgopal@abaca.com>
Cc: Pgsql-Performance ((E-mail)) <pgsql-performance@postgresql.org>
Subject: Re: best way to run maintenance script
Date: Fri, 14 Mar 2008 19:17:22 -0700
Message-ID: <20080314191722.13e19440@commandprompt.com> (raw)
In-Reply-To: <1205545912.12661.22.camel@vinu-ubuntu.abaca>
References: <1205542821.12661.16.camel@vinu-ubuntu.abaca>
	<20080314173235.58f854e6@commandprompt.com>
	<1205545912.12661.22.camel@vinu-ubuntu.abaca>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 14 Mar 2008 17:51:52 -0800
Vinubalaji Gopal <vgopal@abaca.com> wrote:

> 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.

I think you will find if you do it the right way, which is to say the
way that it is meant to be done with the configurable options, your
life will be a great deal more pleasant than some one off hack.

Sincerely,

Joshua D. Drake

- -- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
      PostgreSQL political pundit | Mocker of Dolphins

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFH2zG0ATb/zqfZUUQRAtmeAKCpKUbZP63qmiAPI6x4i9sLaf3LfwCfTPwb
mdS3L7JzlwarEjuu3WGFdaE=
=V7wn
-----END PGP SIGNATURE-----


view thread (9+ messages)  latest in thread

Message-ID: <20080314191722.13e19440@commandprompt.com>
Permalink:  ../20080314191722.13e19440@commandprompt.com/
Also on:    postgresql.org/message-id/20080314191722.13e19440@commandprompt.com

 · 

reply
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: jd@commandprompt.com, vgopal@abaca.com
  Subject: Re: best way to run maintenance script
  In-Reply-To: <20080314191722.13e19440@commandprompt.com>

* 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