Rod Taylor <pg@rbt.ca> 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