Re: Question about (lazy) vacuum

Hannu Krosing <hannu@skype.net> 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