pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAutovacuum Running Timeframe
6+ messages / 5 participants
[nested] [flat]
* Autovacuum Running Timeframe
@ 2016-09-05 09:41 Κοκμάδης Δημήτριος <dkokmadis@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Κοκμάδης Δημήτριος @ 2016-09-05 09:41 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Autovacuum Running Timeframe
@ 2016-09-05 09:44 Amar <amarno1@gmail.com>
parent: Κοκμάδης Δημήτριος <dkokmadis@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Amar @ 2016-09-05 09:44 UTC (permalink / raw)
To: Κοκμάδης Δημήτριος <dkokmadis@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Autovacuum Running Timeframe
@ 2016-09-12 22:39 Gaetano Mendola <mendola@gmail.com>
parent: Amar <amarno1@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Gaetano Mendola @ 2016-09-12 22:39 UTC (permalink / raw)
To: Amar <amarno1@gmail.com>; Κοκμάδης Δημήτριος <dkokmadis@gmail.com>; +Cc: pgsql-admin
Are you sure, that's not the recommended use.
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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Autovacuum Running Timeframe
@ 2016-09-13 10:36 jaime soler <jaime.soler@gmail.com>
parent: Gaetano Mendola <mendola@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: jaime soler @ 2016-09-13 10:36 UTC (permalink / raw)
To: Gaetano Mendola <mendola@gmail.com>; Amar <amarno1@gmail.com>; Κοκμάδης Δημήτριος <dkokmadis@gmail.com>; +Cc: 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@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
> >
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Autovacuum Running Timeframe
@ 2016-09-13 11:04 Amar <amarno1@gmail.com>
parent: jaime soler <jaime.soler@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Amar @ 2016-09-13 11:04 UTC (permalink / raw)
To: jaime.soler@gmail.com; +Cc: Gaetano Mendola <mendola@gmail.com>; Κοκμάδης Δημήτριος <dkokmadis@gmail.com>; pgsql-admin
Yes, don't disable auto vacuum.
On Tue, Sep 13, 2016 at 11:36 AM, jaime soler <jaime.soler@gmail.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@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
>
>
--
~Amar
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Autovacuum Running Timeframe
@ 2016-09-13 15:32 Kevin Grittner <kgrittn@gmail.com>
parent: Amar <amarno1@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Kevin Grittner @ 2016-09-13 15:32 UTC (permalink / raw)
To: Amar <amarno1@gmail.com>; +Cc: jaime.soler@gmail.com, Gaetano Mendola <mendola@gmail.com>; Κοκμάδης Δημήτριος <dkokmadis@gmail.com>; pgsql-admin
On Tue, Sep 13, 2016 at 6:04 AM, Amar <amarno1@gmail.com> wrote:
> Yes, don't disable auto vacuum.
+1
Autovacuum will have far less work to do during peak hours if you
have an off-peak-hours crontab job to run VACUUM ANALYZE. You
might want to consider doing that at the database level, run using
a database superuser login.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2016-09-13 15:32 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-09-05 09:41 Autovacuum Running Timeframe Κοκμάδης Δημήτριος <dkokmadis@gmail.com>
2016-09-05 09:44 ` Amar <amarno1@gmail.com>
2016-09-12 22:39 ` Gaetano Mendola <mendola@gmail.com>
2016-09-13 10:36 ` jaime soler <jaime.soler@gmail.com>
2016-09-13 11:04 ` Amar <amarno1@gmail.com>
2016-09-13 15:32 ` Kevin Grittner <kgrittn@gmail.com>
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