Lock partitions - Mailing list pgsql-hackers

From Bruce Momjian
Subject Lock partitions
Date
Msg-id 200609102357.k8ANvWH21860@momjian.us
Whole thread Raw
Responses Re: Lock partitions
List pgsql-hackers
I see this in the CVS commits for 8.2.  Did we determine the proper
number of lock partitions?  Should it be based on the number of buffers
or concurrent sessions allowed?
Divide the lock manager's shared state into 'partitions', so as toreduce contention for the former single LockMgrLock.
Permy recentproposal.  I set it up for 16 partitions, but on a pgbench test thisgives only a marginal further
improvementover 4 partitions --- we needto test more scenarios to choose the number of partitions.
 

--  Bruce Momjian   bruce@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: contrib uninstall scripts need some love
Next
From: Tom Lane
Date:
Subject: Re: Fixed length data types issue