Re: 8.2 Partition lock changes and resource queuing.

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: 8.2 Partition lock changes and resource queuing.
Дата
Msg-id 457CBAE4.8030500@paradise.net.nz
обсуждение исходный текст
Ответ на Re: 8.2 Partition lock changes and resource queuing.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> Mark Kirkwood <markir@paradise.net.nz> writes:
>> The other approach I wondered about was arranging for the resource locks 
>> and related data structures to all use an *additional* partition lock - 
>> which would mean faking a LOCKTAG that always hashed to 
>> NUM_LOCK_PARTITIONS, and using that everywhere in the resource code...
> 
> That seems mighty ugly, as well as defeating the purpose of spreading
> the LWLock contention around evenly.  

Yes - and possibly confusing to amend later, when I (or someone else) 
had forgotten why it was done that way...

> I'd go for letting the resource
> locks go into their natural hash partitions, and making a separate LWLock
> for your other data structures.  (Some day you might get to the point of
> wanting to partition the other data structures, in which case you'd be
> glad you separated the locks.)

Great, thanks for the quick reply!

Cheers

Mark


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: psql display of Unicode combining characters in 8.2
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Postgres95 archives in mbox format