Rod Taylor <[EMAIL PROTECTED]> writes: > As I understand it vacuum operates outside of the regular transaction
It's a perfectly normal transaction. > Is it reasonable to cancel and restart the vacuum process periodically No. How big is that table, anyway? Are you trying a VACUUM FULL, or plain vacuum? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq