Postgres 7.4 and vacuum_cost_delay.
От | Chris Mckenzie |
---|---|
Тема | Postgres 7.4 and vacuum_cost_delay. |
Дата | |
Msg-id | DE02FD24E5A7504FA1D53631DA8CEA9BF8B614@sottmxs10.entrust.com обсуждение исходный текст |
Ответы |
Re: Postgres 7.4 and vacuum_cost_delay.
Re: Postgres 7.4 and vacuum_cost_delay. |
Список | pgsql-performance |
Hi everyone.
I've got a quick and stupid question: Does Postgres 7.4 (7.x) support vacuum_cost_delay?
For all my googles and documentation reading I've determined it's not supported, only because I can't find a 7.x doc or forum post claiming otherwise.
Upgrading to 8.x is out of the question, but I still need to employ something to auto-vacuum a large and active database (possibly more than once a day) in a manner that wouldn't affect load at the wrong time.
If I could combine pg_autovacuum with vacuum_cost_delay I could potentially have a solution. (barring some performance testing)
The only problem with pg_autovacuum is the need for pg_statio, which itself will reduce performance at all times.
Any suggestions?
Thanks!
- Chris
В списке pgsql-performance по дате отправления: