Doug McNaught <doug@wireboard.com> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> Upshot: a client holding an open transaction, plus another client trying
>> to do VACUUM, can clog up the database for everyone else.
> Thanks for the clarification. But the original poster's problem, that
> VACUUM caused his transactions to fail, theoretically shouldn't
> happen--right?
It wasn't clear to me that anything was actually failing, as opposed to
just getting blocked for a long time. Mike?
regards, tom lane