Re: best way to run maintenance script - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: best way to run maintenance script
Date
Msg-id 20080314191722.13e19440@commandprompt.com
Whole thread Raw
In response to Re: best way to run maintenance script  (Vinubalaji Gopal <vgopal@abaca.com>)
Responses Re: best way to run maintenance script
List pgsql-performance
-----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-----

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: best way to run maintenance script
Next
From: Vinubalaji Gopal
Date:
Subject: Re: best way to run maintenance script