Re: ANALYZE locks pg_listener in EXCLUSIVE for long time? - Mailing list 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