"Satoshi Nagayasu" <snaga(at)snaga(dot)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