Re: Proposal of tunable fix for scalability of 8.4
От | Matthew Wakeling |
---|---|
Тема | Re: Proposal of tunable fix for scalability of 8.4 |
Дата | |
Msg-id | alpine.DEB.2.00.0903181141000.21772@aragorn.flymine.org обсуждение исходный текст |
Ответ на | Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs <simon@2ndQuadrant.com>) |
Ответы |
Re: Proposal of tunable fix for scalability of 8.4
|
Список | pgsql-performance |
On Wed, 18 Mar 2009, Simon Riggs wrote: > I agree with that, apart from the "granting no more" bit. > > The most useful behaviour is just to have two modes: > * exclusive-lock held - all other x locks welcome, s locks queue > * shared-lock held - all other s locks welcome, x locks queue The problem with making all other locks welcome is that there is a possibility of starvation. Imagine a case where there is a constant stream of shared locks - the exclusive locks may never actually get hold of the lock under the "all other shared locks welcome" strategy. Likewise with the reverse. Taking a snapshot and queueing all newer locks forces fairness in the locking strategy, and avoids one of the sides getting starved. Matthew -- I've run DOOM more in the last few days than I have the last few months. I just love debugging ;-) -- Linus Torvalds
В списке pgsql-performance по дате отправления: