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

2005-02-07 Thread Tom Lane
Hannu Krosing <[EMAIL PROTECTED]> 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 bac

[HACKERS] Is there a way to make VACUUM run completely outside transaction

2005-02-07 Thread Hannu Krosing
Hi As VACUUM is not something that can be rolled back, could we not make it run completely outside transactions. It already needs to be run outside a transaction block. I try to explain the problem more thoroughly below (I'm quite sleepy, so the explanation may be not too clear ;) My problem is