Philip Warner <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
