On Fri, Jun 11, 2010 at 11:20 AM, Takahiro Itagaki <itagaki.takah...@oss.ntt.co.jp> wrote: > > Bruce Momjian <br...@momjian.us> 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 interval of updates to 500ms or so if do it, > but I rethink ps display is not the best place for the information. > > I'd like to modify the additonal message "waiting for max_standby_delay" > just to "waiting", because we don't use "waiting for statement_timeout" > for normal queries.
+1 I don't think that it's useful to display the value of max_standby_delay. > If we need additional information about conflictions in recovery, > we would supply them with SQL views instead of ps display in 9.1. +1 Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers