| From: | jaime soler <jaime(dot)soler(at)gmail(dot)com> |
|---|---|
| To: | Gaetano Mendola <mendola(at)gmail(dot)com>, 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-13 10:36:19 |
| Message-ID: | 1473762979.896.3.camel@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
> >
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amar | 2016-09-13 11:04:08 | Re: Autovacuum Running Timeframe |
| Previous Message | jaime soler | 2016-09-13 10:33:41 | Re: How to list ALL PostgreSQL functions? |