Re: Review: Hot standby

On Fri, 2008-11-28 at 11:14 -0500, Tom Lane wrote:
> Simon Riggs <simon@2ndQuadrant.com> writes:
> > After some thought, the way I would handle this is by sending a slightly
> > different kind of signal.
> 
> > We can send a shared invalidation message which means "end the
> > transaction, whether or not you are currently running a statement".
> 
> No, a thousand times no. 

So you're against it? ;-)

>  The sinval queue is an *utterly* inappropriate
> mechanism for such a thing.

To be honest, it did seem quite a neat solution. Any particular
direction of thought you'd like me to pursue instead?

Asking the backend to kill itself is much cleaner than the other ways I
imagined. So my other thoughts steer towards hijacking the SIGUSR1
signal somehow for my nefarious purposes. Would that way sound OK? 

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support