Re: Autovacuum Running Timeframe

From: Amar <amarno1(at)gmail(dot)com>
To: jaime(dot)soler(at)gmail(dot)com
Cc: Gaetano Mendola <mendola(at)gmail(dot)com>, Κοκμάδης Δημήτριος <dkokmadis(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Autovacuum Running Timeframe
Date: 2016-09-13 11:04:08
Message-ID: CAKNt1ApagpWoXahozZ2x+h2OOHrchxh6Ejd17E24WkwGrORKtQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Yes, don't disable auto vacuum.

On Tue, Sep 13, 2016 at 11:36 AM, jaime soler <jaime(dot)soler(at)gmail(dot)com> wrote:

> El lun, 12-09-2016 a las 22:39 +0000, Gaetano Mendola escribió:
>
> Are you sure, that's not the recommended use.
>
>
> I also don't recommend to disable autovacuum why don't you programme a
> batch task that executes vacuum in low activity hours
>
>
> 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
>
>

--
~Amar

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Poul Kristensen 2016-09-13 11:25:21 The sizing of HW resources of a physical PG server
Previous Message jaime soler 2016-09-13 10:36:19 Re: Autovacuum Running Timeframe