Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum and Transactions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Vacuum and Transactions
Date
Msg-id 8007.1128436188@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum and Transactions  (Rod Taylor <pg@rbt.ca>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: [PERFORM] A Better External Sort?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: effective SELECT from child tables