Re: Manual Vacuum Analyze Take More Time

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..

<http://www.shreeyansh.com>

On Wed, Nov 28, 2018 at 7:52 PM Moin Akther <moindba(at)hotmail(dot)com> 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
>
>
> Thanks and Best Regards,
> *Moin Akther*
> Email: moindba(at)hotmail(dot)com
>
>
>
>