Re: Why does VACUUM FULL bother locking pages?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why does VACUUM FULL bother locking pages?
Дата
Msg-id 29307.1127403507@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Why does VACUUM FULL bother locking pages?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Oh, certainly!  In this case, may I point out that scan_heap() does not
> bother locking pages, mentioning that "we assume that holding exclusive
> lock on the relation will keep other backends from looking at the page".
> In particular, it calls PageRepairFragmentation which runs with the page
> unlocked AFAICT.

> Seems like a bug to me.

I agree --- and a pretty silly one considering that there are LockBuffer
calls elsewhere in vacuum.c.  Wonder how old that code is ...
        regards, tom lane


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Why does VACUUM FULL bother locking pages?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: logging blemishes