Hi, Hannu Krosing wrote: >> As I know, you can use show mutex status in MySQL to find which mutex >> is hot. But i don't know in PostgreSQL. > > look at pg_locks system view
Or read about dtrace to analyze lower level locking contention: http://www.postgresql.org/docs/8.3/static/dynamic-trace.html Regards Markus Wanner -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
