Обсуждение: Autovacuum Running Timeframe

Поиск
Список
Период
Сортировка

Autovacuum Running Timeframe

От
Κοκμάδης Δημήτριος
Дата:
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 

Re: Autovacuum Running Timeframe

От
Amar
Дата:
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

Re: Autovacuum Running Timeframe

От
Gaetano Mendola
Дата:

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

Re: Autovacuum Running Timeframe

От
jaime soler
Дата:
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

Re: Autovacuum Running Timeframe

От
Amar
Дата:
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

Re: Autovacuum Running Timeframe

От
Kevin Grittner
Дата:
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