TOAST-table vacuuming (was Re: Idea for reducing planning time) - Mailing list pgsql-hackers

From Tom Lane
Subject TOAST-table vacuuming (was Re: Idea for reducing planning time)
Date
Msg-id 13183.976910208@sss.pgh.pa.us
Whole thread Raw
List pgsql-hackers
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
> Also, is TOAST-table vacuuming fixed now?

Still broken.  Hiroshi had muttered something about fixing the internal
commit of VACUUM so that it's more like a real commit --- including
advancing the transaction ID --- but still doesn't release the exclusive
lock held by VACUUM.  Basically we need to propagate the locks forward
to the new xact instead of releasing them.  I think that would be a nice
clean solution if we could do it.  Do you have any ideas about how?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Idea for reducing planning time
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: Idea for reducing planning time