Re: [PATCH] Support for pg_stat_archiver view - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: [PATCH] Support for pg_stat_archiver view
Date
Msg-id CABUevEyPDEAF0z5t+XfGqCTHKqMRvWpY-9E8ThqKwWo-bMFnrA@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Support for pg_stat_archiver view  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On Wed, Jan 8, 2014 at 6:42 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
On 4 January 2014 13:01, Gabriele Bartolini
<gabriele.bartolini@2ndquadrant.it> wrote:

>> I'd suggest making the view on top of an SRF like pg_stat_replication
>> and pg_stat_activity (for example), instead of a whole lot of separate
>> function calls like the older stats views.
>
> Ok, good idea.

Not sure I see why it needs to be an SRF. It only returns one row.

Good point, it could/should be a general function returning a composite type. 

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [PATCH] Support for pg_stat_archiver view
Next
From: Simon Riggs
Date:
Subject: Re: BDR-project