Re: [HACKERS] Metadata about relation creation & full scans.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Metadata about relation creation & full scans.
Дата
Msg-id 31677.1490194447@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Metadata about relation creation & full scans.  (Andres Freund <andres@anarazel.de>)
Ответы Re: [HACKERS] Metadata about relation creation & full scans.  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On 2017-03-22 10:14:14 -0400, Tom Lane wrote:
>> (2) How you gonna update this in vacuum?  It cannot do a transactional
>> update.

> I think we can just do that in a separate transaction, at the tail end
> of vacuum_rel() - if we crash just before that, not that much is lost.

Blech.  What if someone's queued an exclusive lock request on the table?

Actually though, maybe you could get away with updating the last-vacuum
field nontransactionally.  I think we're already updating some of the
other pg_class fields nontransactionally.
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] WIP: Faster Expression Processing v4
Следующее
От: Andrew Gierth
Дата:
Сообщение: Re: [HACKERS] Hash support for grouping sets