Yes, don't disable auto vacuum.
--
On Tue, Sep 13, 2016 at 11:36 AM, jaime soler <jaime.soler@xxxxxxxxx> 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 hoursOn Mon, Sep 5, 2016, 11:46 Amar <amarno1@xxxxxxxxx> wrote:Hi Dimitris,I would suggest to manually schedule database vacuum using cron jobs, instead of relaying on auto-vacuum.Regards,AmarOn Mon, Sep 5, 2016 at 10:41 AM, Κοκμάδης Δημήτριος <dkokmadis@xxxxxxxxx> wrote:Hello,I have a problem with autovacuumIt 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