Re: Is there a problem running vacuum in the middle of a transaction? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Is there a problem running vacuum in the middle of a transaction?
Date
Msg-id 2126.999789223@sss.pgh.pa.us
Whole thread Raw
In response to Re: Is there a problem running vacuum in the middle of a transaction?  (Doug McNaught <doug@wireboard.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: "Ken Hirsch"
Date:
Subject: Re: Log rotation?
Next
From: Peter Eisentraut
Date:
Subject: Re: [BUGS] Build problem with CVS version