Re: best way to run maintenance script

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: best way to run maintenance script
Дата
Msg-id 20080314191722.13e19440@commandprompt.com
обсуждение исходный текст
Ответ на Re: best way to run maintenance script  (Vinubalaji Gopal <vgopal@abaca.com>)
Ответы Re: best way to run maintenance script
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: best way to run maintenance script
Следующее
От: Vinubalaji Gopal
Дата:
Сообщение: Re: best way to run maintenance script