On 04/03/12 9:40 AM, Tom Lane wrote:
> Alex Matzinger<amatzinger(at)experts-exchange(dot)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