| 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: | Whole Thread | Raw Message | 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 |