Re: Manual Vacuum Analyze Take More Time

From: Ravi Krishna <srkrishna(at)outlook(dot)com>
To: Moin Akther <moindba(at)hotmail(dot)com>
Cc: Keith Fiske <keith(dot)fiske(at)crunchydata(dot)com>, "shreeyansh2014(at)gmail(dot)com" <shreeyansh2014(at)gmail(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Manual Vacuum Analyze Take More Time
Date: 2018-11-28 16:46:15
Message-ID: BYAPR01MB38489C87262DFA96223C3511B9D10@BYAPR01MB3848.prod.exchangelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>
> What will be work around to do routine manual “VACUUM ANALYZE” ? If I do only analyze on a table does it will generate WAL files ?
>

If I am not mistaken analyze will still generate WAL for all recently committed rows whose hint bit is not yet set. analyze will set the hint bit
which will generate the WAL.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Keith Fiske 2018-11-28 17:12:15 Re: Manual Vacuum Analyze Take More Time
Previous Message Moin Akther 2018-11-28 16:42:04 Re: Manual Vacuum Analyze Take More Time