Hannu Krosing <[EMAIL PROTECTED]> writes: > I can't think of any other cases where it could matter, as at least the > work done inside vacuum_rel() itself seema non-rollbackable.
VACUUM FULL's tuple-moving is definitely roll-back-able, so it might be prudent to only do this for lazy VACUUM. But on the other hand, VACUUM FULL holds an exclusive lock on the table so no one else is going to see its effects concurrently anyway. As I said, it needs more thought than I've been able to spare for it yet ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings