Philip Warner <pjw(at)rhyme(dot)com(dot)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