Postgres Pro
Downloads
Home   >   mailing lists

RE: PostgreSQL Full Vacuum Taking 5 to 6 hrs. - Mailing list pgsql-admin

From Ram Pratap Maurya
Subject RE: PostgreSQL Full Vacuum Taking 5 to 6 hrs.
Date
Msg-id KL1PR0601MB443376B10AA745BE4630D7A3F02D9@KL1PR0601MB4433.apcprd06.prod.outlook.com
Whole thread Raw
In response to PostgreSQL Full Vacuum Taking 5 to 6 hrs.  (Ram Pratap Maurya <ram.maurya@lavainternational.in>)
List pgsql-admin
Tree view

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.

 

pgsql-admin by date:

Previous
From: Ram Pratap Maurya
Date:
Subject: RE: PostgreSQL Full Vacuum Taking 5 to 6 hrs.
Next
From: Ram Pratap Maurya
Date:
Subject: Recall: PostgreSQL Full Vacuum Taking 5 to 6 hrs.