Re: ps display "waiting for max_standby_delay"

On Fri, Jun 11, 2010 at 11:20 AM, Takahiro Itagaki
<itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> wrote:
>
> Bruce Momjian <bruce(at)momjian(dot)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