Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum Running Timeframe - Mailing list pgsql-admin

From Amar
Subject Re: Autovacuum Running Timeframe
Date
Msg-id CAKNt1ApepOQuAsfSesO3E6eu1mRt9EfqMK=HME9sx1Z3TScd9g@mail.gmail.com
Whole thread Raw
In response to Autovacuum Running Timeframe  (Κοκμάδης Δημήτριος<dkokmadis@gmail.com>)
Responses Re: Autovacuum Running Timeframe
List pgsql-admin
Tree view
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: Κοκμάδης Δημήτριος
Date:
Subject: Autovacuum Running Timeframe
Next
From: Poul Kristensen
Date:
Subject: recovery.conf