Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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
  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

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group