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 Maxwell||Date: 2006-02-17 22:36:10|
|Subject: Re: qsort again (was Re: [PERFORM] Strange Create|
|Previous:||From: Tom Lane||Date: 2006-02-17 19:43:06|
|Subject: Re: qsort again (was Re: [PERFORM] Strange Create Index |