Re: ps display "waiting for max_standby_delay"

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 <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ None of us is going to be here forever. +