Re: [HACKERS] Tracking replication slot "blockings"

2014-04-16 Thread Andres Freund
On 2014-04-16 19:09:09 +0200, Magnus Hagander wrote: > On Wed, Apr 16, 2014 at 6:56 PM, Andres Freund wrote: > > The xlog removal code just check the "global minimum" required LSN - it > > doesn't check the individual slots. So you'd need to add a bit more code > > to that location. But it'd be eas

Re: [HACKERS] Tracking replication slot "blockings"

2014-04-16 Thread Magnus Hagander
On Wed, Apr 16, 2014 at 6:56 PM, Andres Freund wrote: > Hi, > > On 2014-04-16 18:51:41 +0200, Magnus Hagander wrote: > > I'm thinking it could be interesting to know how many times (or in some > > other useful unit than "times" - how often) a specific replication slot > has > > "blocked" xlog rota

Re: [HACKERS] Tracking replication slot "blockings"

2014-04-16 Thread Andres Freund
Hi, On 2014-04-16 18:51:41 +0200, Magnus Hagander wrote: > I'm thinking it could be interesting to know how many times (or in some > other useful unit than "times" - how often) a specific replication slot has > "blocked" xlog rotation. Since this AFAIK only happens during checkpoints, > it seems i

[HACKERS] Tracking replication slot "blockings"

2014-04-16 Thread Magnus Hagander
I'm thinking it could be interesting to know how many times (or in some other useful unit than "times" - how often) a specific replication slot has "blocked" xlog rotation. Since this AFAIK only happens during checkpoints, it seems it should be "reasonably cheap" to track? It would serve as an indi