Hi Julien, we are running VACUUM FULL on all table and its take 5 to 6 Hrs. Regards, Ram Pratap. -----Original Message----- From: Julien Rouhaud [mailto:rjuju123@xxxxxxxxx] Sent: 08 February 2022 12:23 To: Ram Pratap Maurya Cc: 'pgsql-admin@xxxxxxxxxxxxxxxxxxxx'; Ashish Chugh Subject: Re: PostgreSQL Full Vacuum Taking 5 to 6 hrs. 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?
