Re: Autovacuum Running Timeframe

From: Gaetano Mendola <mendola(at)gmail(dot)com>
To: Amar <amarno1(at)gmail(dot)com>, Κοκμάδης Δημήτριος <dkokmadis(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Autovacuum Running Timeframe
Date: 2016-09-12 22:39:34
Message-ID: CAJycT5rLiGEXdLh-6Kv5ENF=BcB71NN8DyzqgBnqhjDx3XU6ew@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

On Mon, Sep 5, 2016, 11:46 Amar <amarno1(at)gmail(dot)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(at)gmail(dot)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
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message jaime soler 2016-09-13 10:33:41 Re: How to list ALL PostgreSQL functions?
Previous Message Mark Steben 2016-09-12 18:12:38 deleting the old postgres 9.2 cluster after successful pg_upgrade to 9.4