Обсуждение: TOAST-table vacuuming (was Re: Idea for reducing planning time)

Поиск
Список
Период
Сортировка

TOAST-table vacuuming (was Re: Idea for reducing planning time)

От
Tom Lane
Дата:
"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