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://stream.boxwatch.ru/docs/8.3/static/dynamic-trace.html
Regards
Markus Wanner