Home > mailing lists

Re: vacuum is time consuming - Mailing list pgsql-general

From	Laurenz Albe
Subject	Re: vacuum is time consuming
Date	February 2, 2021 11:22:58
Msg-id	12904c49be9e344868c428422d17bd4f62bb43a0.camel@cybertec.at Whole thread Raw
In response to	Re: vacuum is time consuming (Atul Kumar <akumar14871@gmail.com>)
Responses	Re: vacuum is time consuming (Martín Marqués <martin.marques@gmail.com>)
List	pgsql-general

Tree view

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

pgsql-general by date:

From: Atul Kumar
Date: 02 February 2021, 11:14:15
Subject: Re: vacuum is time consuming

From: Laurenz Albe
Date: 02 February 2021, 11:31:22
Subject: Re: count(*) vs count(id)

Re: vacuum is time consuming - Mailing list pgsql-general

Previous

Next