Re: Is there a way to make VACUUM run completely outside transaction

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Is there a way to make VACUUM run completely outside transaction
Date: 2005-02-07 15:51:14
Message-ID: 27236.1107791474@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hannu Krosing <hannu(at)tm(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message pgsql 2005-02-07 16:27:59 Re: Query optimizer 8.0.1 (and 8.0)
Previous Message Tom Lane 2005-02-07 15:47:20 Re: Thinking about breaking up the BufMgrLock