Re: Avoid endless futile table locks in vacuuming.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Avoid endless futile table locks in vacuuming.
Дата
Msg-id 4893.1451425671@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Avoid endless futile table locks in vacuuming.  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
Jeff Janes <jeff.janes@gmail.com> writes:
> If we are not doing a scan_all and we fail to acquire a clean-up lock on
> the last block, and the last block reports that it needs freezing, then we
> continue on to wait for the clean-up lock. But there is no need, we don't
> really need to freeze the block, and we already know whether it has tuples
> or not without the clean up lock.  Couldn't we just set the flag based on
> hastup, then 'continue'?

Uh, isn't that what my patch is doing?
        regards, tom lane



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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: Making tab-complete.c easier to maintain
Следующее
От: Joe Conway
Дата:
Сообщение: Re: exposing pg_controldata and pg_config as functions