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