Measuring Lock Performance

From: "Lane Van Ingen" <lvaningen(at)esncc(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Measuring Lock Performance
Date: 2006-02-17 20:26:19
Message-ID: EKEMKEFLOMKDDLIALABIEECNCIAA.lvaningen@esncc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Does anybody know if it is possible to use the statistics collected by
PostgreSQL to do the following, and how?

- view all locks held by a particular PostgreSQL session (including how to
determine
the session ID#)

- determine effect of lock contention on overall database performance, as
well as the
extent to which contention varies with overall database traffic

I am using version 8.0.2 on Windows 2003.

Browse pgsql-performance by date

  From Date Subject
Next Message Gregory Maxwell 2006-02-17 22:36:10 Re: qsort again (was Re: [PERFORM] Strange Create
Previous Message Tom Lane 2006-02-17 19:43:06 Re: qsort again (was Re: [PERFORM] Strange Create Index