Dropping the BEGIN has cleared up the issue. Thank you.
On 4/3/2012 9:50 AM, John R Pierce wrote:
On 04/03/12 9:40 AM, Tom Lane wrote:
Alex Matzinger<amatzin...@experts-exchange.com> writes:
> The connection that is executing the SELECT 1 are generally open
for 1-5
> hours before they are killed. The specific connection only executes
> SELECT 1. The transaction is simply BEGIN, and then SELECT 1's, no
> other query is executed.
Lose the "BEGIN" and it will probably work more nicely.
indeed,a 1-5 hour long transaction means VACUUM can't clean up
anything newer than the oldest active transaction, and thats not per
database, thats cluster-wide.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
