Re: scheduling autovacuum at lean hours only.

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: pgsql-performance(at)postgresql(dot)org, Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>
Subject: Re: scheduling autovacuum at lean hours only.
Date: 2009-02-11 13:54:34
Message-ID: 920307.27884.qm@web23606.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> From: Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)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 setting to off in the conf file and reload.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2009-02-11 14:57:45 Re: scheduling autovacuum at lean hours only.
Previous Message Guillaume Cottenceau 2009-02-11 13:41:52 Re: scheduling autovacuum at lean hours only.