Re: Synchronization Primitives

On Thu, 2008-11-13 at 18:55 +0800, 崔岩ccuiyyan@sina.com 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