Re: Prepared Xacts and Vacuum question - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Prepared Xacts and Vacuum question
Date
Msg-id 11536.1140369016@sss.pgh.pa.us
Whole thread Raw
In response to Prepared Xacts and Vacuum question  ("Satoshi Nagayasu" <snaga@snaga.org>)
Responses Re: Prepared Xacts and Vacuum question
List pgsql-hackers
"Satoshi Nagayasu" <snaga@snaga.org> writes:
> When I was playing with VACUUM, I found that if I have prepared xacts
> on the database A, I can't vacuum full on the database B.

A prepared xact is the same as an open xact as far as vacuum is
concerned.  It's a bad idea to sit on either open or prepared xacts
for long periods ...

> I think the prepared xacts on any database mustn't affect to another database.

Wrong, consider updates to shared catalogs.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Douglas McNaught
Date:
Subject: Re: pg_service.conf
Next
From: Tom Lane
Date:
Subject: Re: possible design bug with PQescapeString()