On Friday 04 March 2005 11:38, Josh Berkus wrote:
> Darcy, Chris,
>
> FWIW, I'm looking at their system now and am seeing persistent lock
> contention on pg_listener:
>
>  relation | database  | transaction |  pid  |     mode      | granted
> ----------+-----------+-------------+-------+---------------+---------
>     16414 | 318624738 |             | 18883 | ExclusiveLock | f
>     16414 | 318624738 |             | 19028 | ExclusiveLock | f
>     16414 | 318624738 |             | 19205 | ExclusiveLock | t
>
>
> This lock contention seems constant.       Why would pg_listener be having
> blocking exclusive locks?

That I'm not sure of, but slony uses notify/listen to notify of specific 
events.  what process is tied to PID 19205 ?

>
> --Josh