<br><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">I've applied the patch yesterday as well, and indeed this does seem to help a lot.<br>
I'm only seeing about 35 connections now (with 25 clients), no more hanging queries either.<br><br></blockquote><div><br></div><div>So in general with that patch connection counts look better however I'm still seeing connections as IDLE in transaction with hanging open transactions even if the server didn't outright fall over this time...</div>
<div><br></div><div>So it looks like there's still some underlying issue even if this mitigates some of it.</div><div><br></div><div>Here's my current pg_stat_activity for IDLE in transaction connections:</div><div>
<br></div><div><span style="color:rgb(0,0,0);font-family:'Segoe UI',Helvetica,Arial,sans-serif;font-size:13px">datid | datname | procpid | usesysid | usename | current_query | waiting | xact_start | query_start | backend_start | client_addr | client_port </span><br style="color:rgb(0,0,0);font-family:'Segoe UI',Helvetica,Arial,sans-serif;font-size:13px">
<span style="color:rgb(0,0,0);font-family:'Segoe UI',Helvetica,Arial,sans-serif;font-size:13px">-------+-------------+---------+----------+-----------+-----------------------+---------+-------------------------------+-------------------------------+-------------------------------+-------------+-------------</span><br style="color:rgb(0,0,0);font-family:'Segoe UI',Helvetica,Arial,sans-serif;font-size:13px">
<span style="color:rgb(0,0,0);font-family:'Segoe UI',Helvetica,Arial,sans-serif;font-size:13px"> 16384 | spaceschema | 17267 | 16388 | spaceuser | <IDLE> in transaction | f | 2012-12-07 16:23:51.178637+00 | 2012-12-07 16:23:51.178966+00 | 2012-12-07 16:12:34.620533+00 | 127.0.0.1 | 45196</span><br style="color:rgb(0,0,0);font-family:'Segoe UI',Helvetica,Arial,sans-serif;font-size:13px">
<span style="color:rgb(0,0,0);font-family:'Segoe UI',Helvetica,Arial,sans-serif;font-size:13px"> 16384 | spaceschema | 16102 | 16388 | spaceuser | <IDLE> in transaction | f | 2012-12-07 16:13:19.062683+00 | 2012-12-07 16:13:19.063373+00 | 2012-12-07 16:08:49.622536+00 | 127.0.0.1 | 44779</span><br style="color:rgb(0,0,0);font-family:'Segoe UI',Helvetica,Arial,sans-serif;font-size:13px">
<span style="color:rgb(0,0,0);font-family:'Segoe UI',Helvetica,Arial,sans-serif;font-size:13px"> 16384 | spaceschema | 12847 | 16388 | spaceuser | <IDLE> in transaction | f | 2012-12-07 16:23:51.141108+00 | 2012-12-07 16:23:51.14131+00 | 2012-12-07 15:57:34.622143+00 | 127.0.0.1 | 43979</span><br style="color:rgb(0,0,0);font-family:'Segoe UI',Helvetica,Arial,sans-serif;font-size:13px">
<span style="color:rgb(0,0,0);font-family:'Segoe UI',Helvetica,Arial,sans-serif;font-size:13px"> 16384 | spaceschema | 17468 | 16388 | spaceuser | <IDLE> in transaction | f | 2012-12-07 16:13:19.225653+00 | 2012-12-07 16:13:19.226371+00 | 2012-12-07 16:13:19.123346+00 | 127.0.0.1 | 45215</span><br style="color:rgb(0,0,0);font-family:'Segoe UI',Helvetica,Arial,sans-serif;font-size:13px">
<span style="color:rgb(0,0,0);font-family:'Segoe UI',Helvetica,Arial,sans-serif;font-size:13px"> 16384 | spaceschema | 17471 | 16388 | spaceuser | <IDLE> in transaction | f | 2012-12-07 16:23:51.260104+00 | 2012-12-07 16:23:51.260277+00 | 2012-12-07 16:13:19.340865+00 | 127.0.0.1 | 45218</span><br>
</div><div><span style="color:rgb(0,0,0);font-family:'Segoe UI',Helvetica,Arial,sans-serif;font-size:13px"><br></span></div><div><span style="color:rgb(0,0,0);font-family:'Segoe UI',Helvetica,Arial,sans-serif;font-size:13px">Checking the locks table shows that these all have locks on something ....</span></div>
<div><span style="color:rgb(0,0,0);font-family:'Segoe UI',Helvetica,Arial,sans-serif;font-size:13px"><br></span></div><div><span style="color:rgb(0,0,0);font-family:'Segoe UI',Helvetica,Arial,sans-serif;font-size:13px"><br>
</span></div></div><br></div>