Search Postgresql Archives

Re: vacuum is time consuming

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: vacuum is time consuming
From: Laurenz Albe <laurenz.albe@xxxxxxxxxxx>
Date: Tue, 02 Feb 2021 09:22:58 +0100
Cc: Postgres General <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CA+ONtZ6v-UXKb6ha0a5-E7NrXFbpLZXk5VcLCf5baGjKZo4tDQ@mail.gmail.com>
References: <CA+ONtZ5eU7cD3wqsdPJhmCanvTqJg3rNSQ_piCxszdEwFvjE8w@mail.gmail.com> <CABeG9LuU1Y7JF4brZ-9eRj_LoEY=U9UQAM1HzLtuoWsCBFYC+g@mail.gmail.com> <CA+ONtZ6v-UXKb6ha0a5-E7NrXFbpLZXk5VcLCf5baGjKZo4tDQ@mail.gmail.com>
User-agent: Evolution 3.36.5 (3.36.5-2.fc32)

On Tue, 2021-02-02 at 13:44 +0530, Atul Kumar wrote:
> Is there any other option to increase the speed of vacuum?

For autovacuum, decrease "autovacuum_vacuum_cost_delay".

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: vacuum is time consuming
  - From: Martín Marqués

References:
- vacuum is time consuming
  - From: Atul Kumar
- Re: vacuum is time consuming
  - From: Martín Marqués
- Re: vacuum is time consuming
  - From: Atul Kumar

Prev by Date: Re: vacuum is time consuming
Next by Date: Re: count(*) vs count(id)
Previous by thread: Re: vacuum is time consuming
Next by thread: Re: vacuum is time consuming
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux