Re: ANALYZE locks pg_listener in EXCLUSIVE for long time?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ANALYZE locks pg_listener in EXCLUSIVE for long time?
Дата
Msg-id 4772.1083558806@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  (Philip Warner <pjw@rhyme.com.au>)
Список pgsql-hackers
Philip Warner <pjw@rhyme.com.au> writes:
> At 02:21 PM 3/05/2004, Tom Lane wrote:
>> [blinks...]  There's something pretty strange about that.  Are you using
>> LISTEN/NOTIFY at all?

> Nope.

In that case there's no reason for anything to be taking any particular
locks on pg_listener; and it's simply not possible for ANALYZE to spend
half an hour on a zero-page table if it's not blocked by a lock.  Could
you dig a little deeper and see where the problem really is?
        regards, tom lane


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

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