Re: Lock partitions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Lock partitions
Дата
Msg-id 5772.1157934630@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Lock partitions  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Lock partitions  (Mark Wong <markw@osdl.org>)
Re: Lock partitions  (Mark Wong <markw@osdl.org>)
Список pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> 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?

No.  NUM_LOCK_PARTITIONS needs to be a compile-time constant for a
number of reasons, and there is absolutely zero evidence to justify
making any effort (and spending any cycles) on a variable value.

It would be nice to see some results from the OSDL tests with, say, 4,
8, and 16 lock partitions before we forget about the point though.
Anybody know whether OSDL is in a position to run tests for us?
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: contrib uninstall scripts need some love
Следующее
От: Kevin Brown
Дата:
Сообщение: Re: Foreign keys