Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there a way to make VACUUM run completely outside transaction - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Is there a way to make VACUUM run completely outside transaction
Date
Msg-id 27236.1107791474@sss.pgh.pa.us
Whole thread Raw
In response to Is there a way to make VACUUM run completely outside transaction  (Hannu Krosing <hannu@tm.ee>)
Responses Re: Is there a way to make VACUUM run completely outside  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
Tree view 
Hannu Krosing <hannu@tm.ee> writes:
> As VACUUM is not something that can be rolled back, could we not make it
> run completely outside transactions.

No, because it has to be able to hold a table-level lock on the target
table.  Besides, where did you get the idea that it can't be rolled back?
The VACUUM FULL case, at least, has to go through huge pushups to be
sure it is rollback-safe.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Thinking about breaking up the BufMgrLock
Next
From: pgsql@mohawksoft.com
Date:
Subject: Re: Query optimizer 8.0.1 (and 8.0)