Re: pg_stats_recovery view

On Thu, Feb 2, 2012 at 4:32 PM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> On Thu, Feb 2, 2012 at 08:26, Jaime Casanova <jaime(at)2ndquadrant(dot)com> wrote:
>> On Wed, Feb 1, 2012 at 9:18 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>>>>>
>>>>> --On 15. Januar 2012 02:50:00 -0500 Jaime Casanova <jaime(at)2ndquadrant(dot)com>
>>>>> wrote:
>>>>>
>>>>>> Attached is a patch thats implements a pg_stat_recovery view that
>>>>>> keeps counters about processed wal records. I just notice that it
>>>>>> still lacks documentation but i will add it during the week.
>>>>>
>>>>>
>>>
>>> Before reviewing the patch, I'd like to know: what's the purpose of this view?
>>> It's only debug purpose? ISTM that most users don't care about this view at all.
>>>
>>
>> yeah! you're right. most users won't care about it... did i tell that
>> i added a track_recovery GUC so only users that wanted pay for it? i
>> probably did not tell that :D
>
> I haven't looked through the code in detail, but one direct comment:
> do we really need/want to send this through the stats collector? It
> will only ever have one sender - perhaps we should just either store
> it in shared memory or store it locally and only send it on demand?

Agreed. I think we should either.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center