Re: Lock partitions

Поиск
Список
Период
Сортировка
От Mark Wong
Тема Re: Lock partitions
Дата
Msg-id 453662E1.3080802@osdl.org
обсуждение исходный текст
Ответ на Re: Lock partitions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> Mark Wong <markw@osdl.org> writes:
>> Tom Lane wrote:
>>> Hmm, what sort of errors are we talking about?
> 
>> ERROR:  too many LWLocks taken
> 
> That really shouldn't happen ... are you sure you did a full recompile
> after changing NUM_LOCK_PARTITIONS?
> 
> Actually ... wait a moment.  The default value of NUM_LOCK_PARTITIONS
> is already 16 (1 << LOG2_NUM_LOCK_PARTITIONS where the latter is 4).
> Are you saying you set LOG2_NUM_LOCK_PARTITIONS to 16?  That would be
> way too many partitions.  I was thinking of testing
> LOG2_NUM_LOCK_PARTITIONS in the range of about 2 to 5.

Oops, I can't read bit shifting. =p  I'll do again.

Mark


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Lock partitions
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Additional stats for Relations