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 20220208065324.6lrlrqxvau33k5gk@jrouhaud
Whole thread Raw
In response to 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,

On Tue, Feb 08, 2022 at 06:25:01AM +0000, Ram Pratap Maurya wrote:
>
> We are using Postgres -11 version and when we running Full vacuum it will
> take 5 to 6 Hrs to complete full vacuum.

What do you mean by "full vacuum" exactly?  Is it a plain VACUUM FULL?  If yes,
on all tables or only some specific ones?

pgsql-admin by date:

Previous
From: Ram Pratap Maurya
Date:
Subject: PostgreSQL Full Vacuum Taking 5 to 6 hrs.
Next
From: Nikhil Shetty
Date:
Subject: Re: Lost replication slots after pg_upgrade.