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.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
