Query regarding postgres lock contention

From: Hamza Bin Sohail <hsohail(at)purdue(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Query regarding postgres lock contention
Date: 2011-10-05 09:12:43
Message-ID: 675917030.172839.1317805963268.JavaMail.root@mailhub035.itcs.purdue.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hamza Bin Sohail 2011-10-05 09:16:00 Query regarding postgres lock contention - Followup
Previous Message Kohei KaiGai 2011-10-05 08:47:08 Re: [v9.2] DROP statement reworks