Fri Mar 4 19:33:58 PST 2005
- Previous message: [Slony1-general] Slony load on master db
- Next message: [Slony1-general] Slony load on master db
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Slony load on master db
- Next message: [Slony1-general] Slony load on master db
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list