Postgres Pro
Downloads
Home   >   mailing lists

Manual Vacuum Analyze Take More Time - Mailing list pgsql-admin

From Moin Akther
Subject Manual Vacuum Analyze Take More Time
Date
Msg-id 5387ACC6-52FD-42B3-A404-0FB63329CEE1@hotmail.com
Whole thread Raw
Responses Re: Manual Vacuum Analyze Take More Time  (Ron <ronljohnsonjr@gmail.com>)
Re: Manual Vacuum Analyze Take More Time  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
List pgsql-admin
Tree view
Dear All,

While running Manual “VACUUM ANALYZE” on table size of 1.2TB, its running more than 1 Hour and generated almost 15K WAL files and due to this we have faced huge replication lag on our standby db.

I have maitenance_work_mem of 6GB and RAM Size of 128GB.

There is no lock and blocking queries at that time and CPU and memory utilization also normal.

How we can fix this issue ?

DB Version: 9.4


Thanks and Best Regards,

Moin Akther

 

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: canceling statement coming in slave instance
Next
From: Ron
Date:
Subject: Re: Manual Vacuum Analyze Take More Time