Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL Full Vacuum Taking 5 to 6 hrs. - Mailing list pgsql-admin

From Julien Rouhaud
Subject Re: PostgreSQL Full Vacuum Taking 5 to 6 hrs.
Date
Msg-id 20220208070826.6q7tgzumlumzlles@jrouhaud
Whole thread Raw
In response to RE: PostgreSQL Full Vacuum Taking 5 to 6 hrs.  (Ram Pratap Maurya <ram.maurya@lavainternational.in>)
Responses RE: PostgreSQL Full Vacuum Taking 5 to 6 hrs.  (Ram Pratap Maurya <ram.maurya@lavainternational.in>)
List pgsql-admin
Tree view 
Hi,

Please don't top post on those forums
(https://wiki.postgresql.org/wiki/Mailing_Lists#Email_etiquette_mechanics)

On Tue, Feb 08, 2022 at 06:59:07AM +0000, Ram Pratap Maurya wrote:
> 
> we are running VACUUM FULL on all table and its take 5 to 6 Hrs.

The only thing that can be done to make it faster is to use a 1GB
maintenance_work_mem.

But why do you need to do frequent database wide VACUUM FULL in the first
place?  Do you really have massive bloat on every single table in the database?

Do you have adequate autovacuum configuration, or additional VACUUM jobs if
that's not enough?

pgsql-admin by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: Lost replication slots after pg_upgrade.
Next
From: Nikhil Shetty
Date:
Subject: Re: Lost replication slots after pg_upgrade.