RE: 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: RE: PostgreSQL Full Vacuum Taking 5 to 6 hrs.
Date: 2022-02-08 11:33:11
Message-ID: KL1PR0601MB443376B10AA745BE4630D7A3F02D9@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 current PG DB size is 450 GB .

Archive log enable in Database and we are running Full PG_Base backup and it will take 8 to 8:30 Hrs to complete the backup ,

Please suggest how to reduce the full DB backup time.

OS Version : RHEL6

DB size -450 GB

Postgresql Version -11

Regards,
Ram Pratap.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ram Pratap Maurya 2022-02-08 11:33:27 Recall: PostgreSQL Full Vacuum Taking 5 to 6 hrs.
Previous Message Ram Pratap Maurya 2022-02-08 11:25:18 RE: PostgreSQL Full Vacuum Taking 5 to 6 hrs.