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

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