Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Lock Statistics
- From: "Milen A. Radev" <milen(at)radev(dot)net>
- To: pgsql-admin(at)postgresql(dot)org
- Subject: Lock Statistics
- Date: Mon, 30 Jul 2007 19:11:11 +0300
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 - http://pgfoundry.org/projects/pglockdiag/. Unfortunately the projects seems stillborn - no published files and nothing in CVS. -- Milen A. Radev
- Follow-Ups:
- Re: Lock Statistics
- From: Michael Fuhr
- Re: Lock Statistics
- From: adey
- Re: Lock Statistics
- Prev by Date: silent install under Windows giving problems
- Next by Date: Re: Lock Statistics
- Previous by thread: silent install under Windows giving problems
- Next by thread: Re: Lock Statistics
- Indexes: