PostgreSQL Full Vacuum Taking 5 to 6 hrs.

From: Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in>
To: "'pgsql-admin(at)lists(dot)postgresql(dot)org'" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Cc: "Ashish Chugh" <ashish(dot)chugh(at)lavainternational(dot)in>
Subject: PostgreSQL Full Vacuum Taking 5 to 6 hrs.
Date: 2022-02-08 06:25:01
Message-ID: KL1PR0601MB443336C9B802CED1A9B9B1E1F02D9@KL1PR0601MB4433.apcprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Team,

We are using Postgres -11 version and when we running Full vacuum it will take 5 to 6 Hrs to complete full vacuum.

Please suggest how to reduce the full vacuum time.

OS Version : RHEL6

DB size -450 GB

Postgresql Version -11

Regards,
Ram Pratap.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Julien Rouhaud 2022-02-08 06:53:24 Re: PostgreSQL Full Vacuum Taking 5 to 6 hrs.
Previous Message Victor Sudakov 2022-02-08 03:34:28 Re: Lost replication slots after pg_upgrade.