Horton

Re: 2PC-induced lockup

Michael Paesold <mpaesold@gmx.at>

View thread View on postgr.es
From: Michael Paesold <mpaesold@gmx.at>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Peter Eisentraut <peter_e@gmx.net>, pgsql-hackers@postgresql.org
Date: 2007-07-12T18:02:55Z
Lists: pgsql-hackers 
Simon Riggs wrote:
> On Wed, 2007-07-11 at 18:09 -0400, Tom Lane wrote:
> 
>>> There seems like a number of ways that unresolved prepared transactions
>>> can cause problems. We really need to have startup mention how many
>>> prepared transactions there are, so we have some chance of understanding
>>> and resolving potential problems.
>> While I have no particular objection to such a log entry, I doubt it
>> will fix anything; how many people will really think to look in the
>> postmaster log? 
> 
> Even if it were just you and me. From my perspective, thats enough.

At least, such a message seems much more useful than the list of 
historic startup messages that were removed recently. Just my two €-cents.

Best Regards
Michael Paesold