Hi Moin Akther,
It seems you have set good enough maitenance_work_mem and as your table size is large, so you should better to go for the partitioning..
It seems you have set good enough maitenance_work_mem and as your table size is large, so you should better to go for the partitioning..
On Wed, Nov 28, 2018 at 7:52 PM Moin Akther <moindba@xxxxxxxxxxx> wrote:
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
