Re: Scalability in postgres - Mailing list pgsql-performance

From Greg Smith
Subject Re: Scalability in postgres
Date
Msg-id alpine.GSO.2.01.0906051309350.4737@westnet.com
Whole thread Raw
In response to Re: Scalability in postgres  (Mark Mielke <mark@mark.mielke.cc>)
List pgsql-performance
On Thu, 4 Jun 2009, Mark Mielke wrote:

> At it's very simplest, this is the difference between "wake one thread"
> (which is then responsible for waking the next thread) vs "wake all
> threads"....Any system which actually wakes all threads will probably
> exhibit scaling limitations.

The prototype patch we got from Jignesh improved his specific workload by
waking more waiting processes than were being notified in the current
code.  The bottleneck that's been best examined so far at high client
counts is not because of too much waking, it's caused by not enough.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Scalability in postgres
Next
From: Robert Schnabel
Date:
Subject: Re: Why is my stats collector so busy?