Postgres Pro
Downloads
Home   >   mailing lists

Re: scheduling autovacuum at lean hours only. - Mailing list pgsql-performance

From Glyn Astill
Subject Re: scheduling autovacuum at lean hours only.
Date
Msg-id 920307.27884.qm@web23606.mail.ird.yahoo.com
Whole thread Raw
In response to scheduling autovacuum at lean hours only.  (Rajesh Kumar Mallah <mallah.rajesh@gmail.com>)
List pgsql-performance
Tree view 
> From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>

> Is it possible to configure autovacuum to run only
> during certain hours ? We are forced to keep
> it off because it pops up during the peak
> query hours.

AFAIK not directly within the conf.

However you could probably set up a shell script to turn it on and off as and when required via cron; just change the
settingto off in the conf file and reload.

pgsql-performance by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: scheduling autovacuum at lean hours only.
Next
From: Guillaume Cottenceau
Date:
Subject: Re: scheduling autovacuum at lean hours only.