Re: Scalability in postgres

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Scalability in postgres
Дата
Msg-id 4A28E8950200002500027601@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Scalability in postgres  (Scott Carey <scott@richrelevance.com>)
Список pgsql-performance
Scott Carey <scott@richrelevance.com> wrote:

> If you wake up 10,000 threads, and they all can get significant work
> done before yielding no matter what order they run, the system will
> scale extremely well.

But with roughly twice the average response time you would get
throttling active requests to the minimum needed to keep all resources
busy.  (Admittedly a hard point to find with precision.)

> I would think that the 4 or 5 most important locks or concurrency
> coordination points in Postgres have very specific, unique
> properties.

Given the wide variety of uses I'd be cautious about such assumptions.

> In particular, these are interesting references, (not only for
java):

With this wealth of opinion, perhaps they can soon approach IBM's JVM
in their ability to support a large number of threads.  I'm rooting
for them.

-Kevin

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Scalability in postgres
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Scalability in postgres