Re: best way to run maintenance script

Поиск
Список
Период
Сортировка
От Vinubalaji Gopal
Тема Re: best way to run maintenance script
Дата
Msg-id 1205545912.12661.22.camel@vinu-ubuntu.abaca
обсуждение исходный текст
Ответ на Re: best way to run maintenance script  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: best way to run maintenance script  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: best way to run maintenance script  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

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