Lock partitions

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Lock partitions
Дата
Msg-id 200609102357.k8ANvWH21860@momjian.us
обсуждение исходный текст
Ответы Re: Lock partitions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: contrib uninstall scripts need some love
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Fixed length data types issue