Re: ANALYZE locks pg_listener in EXCLUSIVE for long time?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ANALYZE locks pg_listener in EXCLUSIVE for long time?
Дата
Msg-id 4656.1083558078@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ANALYZE locks pg_listener in EXCLUSIVE for long  (Philip Warner <pjw@rhyme.com.au>)
Ответы Re: ANALYZE locks pg_listener in EXCLUSIVE for long
Список pgsql-hackers
Philip Warner <pjw@rhyme.com.au> writes:
> ... for some reason pg_listeners is being locked in ACCESS SHARE the 
> entire time.

> Just vacuuming pg_listener produces:

> vacuum verbose pg_listener;
> INFO:  vacuuming "pg_catalog.pg_listener"
> INFO:  "pg_listener": found 0 removable, 0 nonremovable row versions in 0 pages
> VACUUM

[blinks...]  There's something pretty strange about that.  Are you using
LISTEN/NOTIFY at all?
        regards, tom lane


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

Предыдущее
От: Gavin Sherry
Дата:
Сообщение: Re: ANALYZE locks pg_listener in EXCLUSIVE for long time?
Следующее
От: Philip Warner
Дата:
Сообщение: Re: ANALYZE locks pg_listener in EXCLUSIVE for long