I'd like to use autovacuum to clean up the tables rather than schedule a
full vacuum with cron as it will be more selective/intelligent about what
gets cleaned. But is it possible to stop it running during peak/office
hours?
I've seen a post mention using pg_autovacuum.enabled to do this, but this
appears to be on a per table basis... I'd like to do this across the board,
without restarting the db. Is this possible or do i need to insert every
table into pg_autovacuum and run a script that sets the enabled flag as
appropriate?
Thanks
--
Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
