The Hermit Hacker <scrappy(at)hub(dot)org> writes:
>> Given your other comment about a bunch of waiting backends, it sure
>> sounds like you've got some backend that's sitting on an old open
>> transaction.
> last email about waiting was a different database ... will *that* affect
> this? :(
Not directly, but the "oldest open transaction" is across the whole
installation IIRC. So an old open transaction could prevent VACUUM
from deleting tuples even if the xact is being done in another DB.
regards, tom lane