On Thu, 2008-11-13 at 18:55 +0800, [EMAIL PROTECTED] wrote: > Hi all: > > I am a fresh men in PostgreSQL. And i work on benchmark study > these days using PostgreSQL. > > Now i have a question: Is there some way to show the lock contention > of PostgreSQL? > > 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 -- ------------------------------------------ Hannu Krosing http://www.2ndQuadrant.com PostgreSQL Scalability and Availability Services, Consulting and Training -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers