Re: vacuum is time consuming

From: Martín Marqués <martin(dot)marques(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: Atul Kumar <akumar14871(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: vacuum is time consuming
Date: 2021-02-02 12:34:19
Message-ID: CABeG9Ls7=iWaDbYzwW5gahSOwnwCGJw49uoBWTwMXZ9ozhvN_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

> > Is there any other option to increase the speed of vacuum?
>
> For autovacuum, decrease "autovacuum_vacuum_cost_delay".

He mentioned in the original message that his problems was with a
global VACUUM after upgrading, so cost_delay should be zero by
default.

Regards,

--
Martín Marqués
It’s not that I have something to hide,
it’s that I have nothing I want you to see

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc Millas 2021-02-02 14:44:31 Re: ransomware
Previous Message Andrus 2021-02-02 12:12:06 Re: permission denied for large object 200936761