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

From Ravi Krishna
Subject Re: Manual Vacuum Analyze Take More Time
Date
Msg-id BYAPR01MB38489C87262DFA96223C3511B9D10@BYAPR01MB3848.prod.exchangelabs.com
Whole thread Raw
In response to Re: Manual Vacuum Analyze Take More Time  (Moin Akther <moindba@hotmail.com>)
List pgsql-admin
> 
> What will be work around to do routine manual “VACUUM ANALYZE” ? If I do only analyze on a table does it will
generateWAL files ?
 
> 

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


pgsql-admin by date:

Previous
From: Moin Akther
Date:
Subject: Re: Manual Vacuum Analyze Take More Time
Next
From: Keith Fiske
Date:
Subject: Re: Manual Vacuum Analyze Take More Time