Query regarding postgres lock contention - Mailing list pgsql-hackers

From Hamza Bin Sohail
Subject Query regarding postgres lock contention
Date
Msg-id 675917030.172839.1317805963268.JavaMail.root@mailhub035.itcs.purdue.edu
Whole thread Raw
Responses Query regarding postgres lock contention - Followup  (Hamza Bin Sohail <hsohail@purdue.edu>)
List pgsql-hackers
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 lock contention
can be checked with lockstat (and with pg_locks ? ) but I wanted to know if 
someone can tell me how much contention there would be for this database
in a 16-core system vs a 4-core system. I just need a rough idea.

Any response would be very helpful

Thanks

~Hamza


pgsql-hackers by date:

Previous
From: Kohei KaiGai
Date:
Subject: Re: [v9.2] DROP statement reworks
Next
From: Hamza Bin Sohail
Date:
Subject: Query regarding postgres lock contention - Followup