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
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
In response to
pgsql-hackers by date
|Next:||From: Alex Avriette||Date: 2001-09-06 15:43:40|
|Subject: Re: [GENERAL] DBD::Pg errstr method doesn't return full|
|Previous:||From: Ken Hirsch||Date: 2001-09-06 14:48:52|
|Subject: Re: Log rotation?|