Postgres Pro
Downloads
Home   >   mailing lists

Measuring Lock Performance - Mailing list pgsql-performance

From Lane Van Ingen
Subject Measuring Lock Performance
Date
Msg-id EKEMKEFLOMKDDLIALABIEECNCIAA.lvaningen@esncc.com
Whole thread Raw
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: [HACKERS] qsort again (was Re: Strange Create Index
Next
From: "Gregory Maxwell"
Date:
Subject: Re: [HACKERS] qsort again (was Re: Strange Create