Re: [HACKERS] ps display "waiting for max_standby_delay"

2010-06-10 Thread Fujii Masao
On Fri, Jun 11, 2010 at 11:20 AM, Takahiro Itagaki wrote: > > Bruce Momjian wrote: > >> > how about showing actual waiting time instead? >> >              " waiting for max_standby_delay (%d ms)", >> >              MaxStandbyDelay) >> >> Sounds interesting, but how often would the ps statust disp

Re: [HACKERS] ps display "waiting for max_standby_delay"

2010-06-10 Thread Takahiro Itagaki
Bruce Momjian wrote: > > how about showing actual waiting time instead? > > " waiting for max_standby_delay (%d ms)", > > MaxStandbyDelay) > > Sounds interesting, but how often would the ps statust display be > updated? I hope not too often. We can change the interv

Re: [HACKERS] ps display "waiting for max_standby_delay"

2010-06-10 Thread Bruce Momjian
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

[HACKERS] ps display "waiting for max_standby_delay"

2010-06-06 Thread Takahiro Itagaki
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