Postgres Pro
Downloads
Home   >   mailing lists

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

From Ram Pratap Maurya
Subject PostgreSQL Full Vacuum Taking 5 to 6 hrs.
Date
Msg-id KL1PR0601MB443336C9B802CED1A9B9B1E1F02D9@KL1PR0601MB4433.apcprd06.prod.outlook.com
Whole thread Raw
Responses Re: PostgreSQL Full Vacuum Taking 5 to 6 hrs.  (Julien Rouhaud <rjuju123@gmail.com>)
RE: 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 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.

 

pgsql-admin by date:

Previous
From: Victor Sudakov
Date:
Subject: Re: Lost replication slots after pg_upgrade.
Next
From: Julien Rouhaud
Date:
Subject: Re: PostgreSQL Full Vacuum Taking 5 to 6 hrs.