From: | Chris Mckenzie <Chris(dot)McKenzie(at)entrust(dot)com> |
---|---|
To: | "'pgsql-performance(at)postgresql(dot)org'" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Postgres 7.4 and vacuum_cost_delay. |
Date: | 2006-05-01 18:40:41 |
Message-ID: | DE02FD24E5A7504FA1D53631DA8CEA9BF8B614@sottmxs10.entrust.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Myllymaki | 2006-05-01 18:43:20 | Re: hardare config question |
Previous Message | Vivek Khera | 2006-05-01 18:29:12 | Re: hardare config question |