On Tue, May 17, 2022 at 1:32 AM Bharath Rupireddy <bharath.rupireddyforpostg...@gmail.com> wrote: > In a production environment (of course with a better management of > server logs) one can set log_wal_traffic to "high" and emit the > required info to answer some of the customer questions like - "How far > the server is in recovery? How much time recovery of each WAL file > approximately took? How much time will it take to recover all the WAL > files? What's the rate of recovery - time per WAL file? etc." > > Whereas ereport_startup_progress facility will help to emit log > messages only if "some" operation takes longer than set > log_startup_progress_interval time which may not serve the above > purpose.
I think you are misunderstanding what an "operation" is here. If you take the time to test out that facility, I think you will find that it is quite capable of answering all of those questions. -- Robert Haas EDB: http://www.enterprisedb.com
