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
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 |