Skip site navigation (1) Skip section navigation (2)

Is there a problem running vacuum in the middle of a transaction?

From: Mike Cianflone <mcianflone(at)littlefeet-inc(dot)com>
To: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Is there a problem running vacuum in the middle of a transaction?
Date: 2001-09-06 00:29:58
Message-ID: B9F49C7F90DF6C4B82991BFA8E9D547B17D24C@BUFORD.littlefeet-inc.com (view raw or flat)
Thread:
Lists: pgsql-hackers
	Is there a problem with running vacuum, or vacuum analyze in the
middle of making transactions? If there happens to be a transaction running
at the time I do a vacuum analyze, the transaction has problems and the
trigger doesn't get completed all the way, and the transaction fails.

Thanks for any pointers.


Responses

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2001-09-06 02:39:56
Subject: Re: Log rotation?
Previous:From: Bruce MomjianDate: 2001-09-06 00:03:26
Subject: Re: Performance TODO items

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group