"Satoshi Nagayasu" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend