Takahiro Itagaki wrote: > Hi, > > We have codes to change ps display for recovery process during hot standby. > The current code always shows max_standby_delay for the message, but how > about showing actual waiting time instead? Since DBAs can always get the > parameter from postgresql.conf they wrote, so the parameter value itself > is not so useful. Actual waiting time might be more useful to determine > which values to be set to max_standby_delay, no? > > [backend/storage/ipc/standby.c] > snprintf(new_status + len, 50, > " waiting for max_standby_delay (%d ms)", > MaxStandbyDelay); ==> GetCurrentTimestamp() - waitStart > set_ps_display(new_status, false); > > I think SQL-based activity view will be more useful than ps display, > but it's an item for 9.1.
Sounds interesting, but how often would the ps statust display be updated? I hope not too often. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + None of us is going to be here forever. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
