| From: | Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in> |
|---|---|
| To: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
| Cc: | "'pgsql-admin(at)lists(dot)postgresql(dot)org'" <pgsql-admin(at)lists(dot)postgresql(dot)org>, "Ashish Chugh" <ashish(dot)chugh(at)lavainternational(dot)in> |
| Subject: | RE: PostgreSQL Full Vacuum Taking 5 to 6 hrs. |
| Date: | 2022-02-08 06:59:07 |
| Message-ID: | KL1PR0601MB44339FD28B5E47B77799B42AF02D9@KL1PR0601MB4433.apcprd06.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)gmail(dot)com]
Sent: 08 February 2022 12:23
To: Ram Pratap Maurya
Cc: 'pgsql-admin(at)lists(dot)postgresql(dot)org'; 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Julien Rouhaud | 2022-02-08 07:04:04 | Re: Lost replication slots after pg_upgrade. |
| Previous Message | Nikhil Shetty | 2022-02-08 06:54:56 | Re: Lost replication slots after pg_upgrade. |