Josh Berkus josh
Fri Mar 4 19:33:58 PST 2005
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?

--Josh

-- 
__Aglio Database Solutions_______________
Josh Berkus		       Consultant
josh at agliodbs.com	 www.agliodbs.com
Ph: 415-752-2500	Fax: 415-752-2387
2166 Hayes Suite 200	San Francisco, CA


More information about the Slony1-general mailing list