Philip Warner <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
