Skip site navigation (1) Skip section navigation (2)

Re: Proposal of tunable fix for scalability of 8.4

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Matthew Wakeling <matthew(at)flymine(dot)org>
Cc: Scott Carey <scott(at)richrelevance(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Proposal of tunable fix for scalability of 8.4
Date: 2009-03-21 08:50:39
Message-ID: 1237625439.3953.539.camel@ebony.2ndQuadrant (view raw or flat)
Thread:
Lists: pgsql-performance
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


In response to

pgsql-performance by date

Next:From: Jignesh K. ShahDate: 2009-03-21 23:02:46
Subject: Re: Proposal of tunable fix for scalability of 8.4
Previous:From: M. Edward (Ed) BoraskyDate: 2009-03-21 04:17:05
Subject: "iowait" bug?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group