On Wed, 2009-04-22 at 21:58 +0300, Heikki Linnakangas wrote: > Tom Lane wrote: > > Does a prepared xact still block vacuum cleanup in HEAD, or has that > > been fixed since 8.2? > > It still does. A prepared xact is just like a idle-in-transaction > backend as far as vacuum is concerned.
I thought idle transactions generally have released all their snapshots (where possible), thus allowing VACUUM to work. I would think something similar could work for prepared transactions. Regards, Jeff Davis -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers