Signaling of waiting for a cleanup lock?

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Signaling of waiting for a cleanup lock?
Дата
Msg-id 20140411142838.GP14419@alap3.anarazel.de
обсуждение исходный текст
Ответы Re: Signaling of waiting for a cleanup lock?  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Hi,

VACUUM sometimes waits synchronously for a cleanup lock on a heap
page. Sometimes for a long time. Without reporting it externally.
Rather confusing ;).

Since we only take cleanup locks around vacuum, how about we report at
least in pgstat that we're waiting? At the moment, there's really no way
to know if that's what's happening.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: WIP patch (v2) for updatable security barrier views
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH] Negative Transition Aggregate Functions (WIP)