Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum Running Timeframe - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: Autovacuum Running Timeframe
Date
Msg-id CAJycT5rLiGEXdLh-6Kv5ENF=BcB71NN8DyzqgBnqhjDx3XU6ew@mail.gmail.com
Whole thread Raw
In response to Re: Autovacuum Running Timeframe  (Amar <amarno1@gmail.com>)
Responses Re: Autovacuum Running Timeframe
List pgsql-admin
Tree view

Are you sure, that's not the recommended use.

On Mon, Sep 5, 2016, 11:46 Amar <amarno1@gmail.com> wrote:
Hi Dimitris,

I would suggest to manually schedule database vacuum using cron jobs, instead of relaying on auto-vacuum.

Regards,
Amar

On Mon, Sep 5, 2016 at 10:41 AM, Κοκμάδης Δημήτριος <dkokmadis@gmail.com> wrote:
Hello,

I have a problem with autovacuum 

It runs randomly, so when it runs in websites high traffic hours it causes problems with site speed.

Is it possible to define specific timezone when autovacuum process could run?

Regards,

Dimitris 



--
~Amar

pgsql-admin by date:

Previous
From: Mark Steben
Date:
Subject: deleting the old postgres 9.2 cluster after successful pg_upgrade to 9.4
Next
From: jaime soler
Date:
Subject: Re: How to list ALL PostgreSQL functions?