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

Lock Statistics

From: "Milen A(dot) Radev" <milen(at)radev(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Lock Statistics
Date: 2007-07-30 16:11:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
I have performance problems with a DB (slow queries) and I suspect the
main cause is that a lot of queries wait for a lock on one small
table. That's why I need some stats about the number and (average)
wait-time for locks (even only for this particular table).

After a bit of googling I found a project in PgFoundry with a
promising description -
Unfortunately the projects seems stillborn - no published files and
nothing in CVS.

Milen A. Radev


pgsql-admin by date

Next:From: adeyDate: 2007-07-30 22:35:25
Subject: Re: Lock Statistics
Previous:From: Kees SmitDate: 2007-07-30 11:28:20
Subject: silent install under Windows giving problems

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