Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> Doug McNaught <doug(at)wireboard(dot)com> writes:
> > Hmmm--AFAIK, VACUUM is supposed to grab locks on the tables it
> > processes, which will block until all open transactions against that
> > table are finished. So either VACUUM or your transactions will have
> > to wait, but they shouldn't interfere with each other.
> 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
Free Dmitry Sklyarov!
We will return to our regularly scheduled signature shortly.
In response to
pgsql-hackers by date
|Next:||From: tomas||Date: 2001-09-06 13:15:26|
|Subject: Conditional NOTIFY is not implemented|
|Previous:||From: D'Arcy J.M. Cain||Date: 2001-09-06 12:33:22|
|Subject: Re: Log rotation?|