Re: Scalability in postgres

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Scalability in postgres
Дата
Msg-id alpine.GSO.2.01.0906051309350.4737@westnet.com
обсуждение исходный текст
Ответ на Re: Scalability in postgres  (Mark Mielke <mark@mark.mielke.cc>)
Список 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 по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Scalability in postgres
Следующее
От: Robert Schnabel
Дата:
Сообщение: Re: Why is my stats collector so busy?