From: jaime soler <jaime.soler@gmail.com>
To: Gaetano Mendola <mendola@gmail.com>
To: Amar <amarno1@gmail.com>
To: Κοκμάδης Δημήτριος <dkokmadis@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Autovacuum Running Timeframe
Date: Tue, 13 Sep 2016 12:36:19 +0200
Message-ID: <1473762979.896.3.camel@gmail.com> (raw)
In-Reply-To: <CAJycT5rLiGEXdLh-6Kv5ENF=BcB71NN8DyzqgBnqhjDx3XU6ew@mail.gmail.com>
References: <CAFY9zExcc5ZA8XSPZi3X1Z++w+87Nt5-=CCyUvpLeR_tPnuJfg@mail.gmail.com>
<CAKNt1ApepOQuAsfSesO3E6eu1mRt9EfqMK=HME9sx1Z3TScd9g@mail.gmail.com>
<CAJycT5rLiGEXdLh-6Kv5ENF=BcB71NN8DyzqgBnqhjDx3XU6ew@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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@gmail.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@gmail.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
> >
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jaime.soler@gmail.com, mendola@gmail.com, amarno1@gmail.com, dkokmadis@gmail.com
Subject: Re: Autovacuum Running Timeframe
In-Reply-To: <1473762979.896.3.camel@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox