Postgres 7.4 and vacuum_cost_delay. - Mailing list pgsql-performance

From Chris Mckenzie
Subject Postgres 7.4 and vacuum_cost_delay.
Date
Msg-id DE02FD24E5A7504FA1D53631DA8CEA9BF8B614@sottmxs10.entrust.com
Whole thread Raw
Responses Re: Postgres 7.4 and vacuum_cost_delay.  ("Jim C. Nasby" <jnasby@pervasive.com>)
Re: Postgres 7.4 and vacuum_cost_delay.  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
List 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 by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: hardare config question
Next
From: Erik Myllymaki
Date:
Subject: Re: hardare config question