Re: [HACKERS] Query regarding postgres lock contention - Followup

2011-10-05 Thread Robert Haas
On Wed, Oct 5, 2011 at 1:48 PM, Kevin Grittner wrote: > Hamza Bin Sohail wrote: > >> My postgres version is 8.3.7 > > Why such an old version?  Why exclude the available bug fixes? > > http://www.postgresql.org/support/versioning > >>> I am aware that lock contention can be checked with lockstat

Re: [HACKERS] Query regarding postgres lock contention - Followup

2011-10-05 Thread Kevin Grittner
Hamza Bin Sohail wrote: > My postgres version is 8.3.7 Why such an old version? Why exclude the available bug fixes? http://www.postgresql.org/support/versioning >> I am aware that lock contention can be checked with lockstat (and >> with pg_locks ? ) but I wanted to know if someone can t

[HACKERS] Query regarding postgres lock contention - Followup

2011-10-05 Thread Hamza Bin Sohail
In addition to the previous post, My postgres version is 8.3.7 >Hi there, > >Just to let you know, I'm not a database expert by any means. >I have configured dbt-2 with postgres and created a database with 4000 >warehouses, >150 customers etc. The database size is over 8G. I am aware that lo