On Fri, 2009-03-20 at 15:28 +0000, Matthew Wakeling wrote: > On Thu, 19 Mar 2009, Scott Carey wrote: > > In type B, the ratio of requests that must context switch is always == > > 1. Every request must queue and wait! > > A remarkably good point, although not completely correct. Every request > that arrives when the lock is held in any way already will queue and wait. > Requests that arrive when the lock is free will run immediately. I admit > it, this is a killer for this particular locking strategy. I think the right mix of theory and test here is for people to come up with new strategies that seem to make sense and then we'll test them all. Trying too hard to arrive at the best strategy purely through discussion will mean we miss a few tricks. Feels like we're on the right track here. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
