Manual Vacuum Analyze Take More Time

From: Moin Akther <moindba(at)hotmail(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Manual Vacuum Analyze Take More Time
Date: 2018-11-28 14:22:22
Message-ID: 5387ACC6-52FD-42B3-A404-0FB63329CEE1@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
Email: moindba(at)hotmail(dot)com<mailto:moindba(at)hotmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2018-11-28 14:55:17 Re: Manual Vacuum Analyze Take More Time
Previous Message Laurenz Albe 2018-11-27 05:12:24 Re: canceling statement coming in slave instance