Doug McNaught <doug(at)wireboard(dot)com> writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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