Hannu Krosing <[EMAIL PROTECTED]> writes:
> Ühel kenal päeval, K, 2006-08-23 kell 05:23, kirjutas Gregory Stark:
>> global xmin it just occurred to me to wonder: Does lazy vacuum need a
>> transaction at all?

> When I asked the same question, I was told that a lot of core
> functionality vacuum uses needs to be in transaction.

Locks for instance; you certainly need a lock on the table.  In general
a whole lot of the backend functionality is bound up in the transaction
start/stop mechanisms, and quite a bit of rearchitecting would be needed
to do very much outside a transaction.  Doesn't really seem worth it.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?


Reply via email to