best way to run maintenance script

Поиск
Список
Период
Сортировка
От Vinubalaji Gopal
Тема best way to run maintenance script
Дата
Msg-id 1205542821.12661.16.camel@vinu-ubuntu.abaca
обсуждение исходный текст
Ответы Re: best way to run maintenance script  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: best way to run maintenance script  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-performance
Hi all,
  I have been searching for the best way to run maintenance scripts
which does a vacuum, analyze and deletes some old data. Whenever the
maintenance script runs - mainly the pg_maintenance --analyze script -
it slows down postgresql inserts and I want to avoid that. The system is
under constant load and I am not interested in the time taken to vacuum.
Is there a utility or mechanism in postgresql which helps in reducing
priority of maintenance queries?

Is writing a postgresql C function and setting the priority of process
the only way to change the priority of the maintenance script or is
there a better way.
http://weblog.bignerdranch.com/?p=11

I tried using the nice command (Linux system) on the maintenance script
- it did not have any effect - guess it does not change the niceness of
the postgresql vacuum process.

(I am running Postgresql 8.0 on a Linux)

--
Vinu

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

Предыдущее
От: Leigh Dyer
Дата:
Сообщение: Re: Adaptec 5805 SAS Raid
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: best way to run maintenance script