Re: Thousands of parallel connections

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Thousands of parallel connections
Дата
Msg-id 18392.1092697736@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Thousands of parallel connections  (Gaetano Mendola <mendola@bigfoot.com>)
Ответы Re: Thousands of parallel connections  (Gaetano Mendola <mendola@bigfoot.com>)
Re: Thousands of parallel connections  (Chris Travers <chris@metatrontech.com>)
Список pgsql-general
Gaetano Mendola <mendola@bigfoot.com> writes:
> I did last week an Ariadne+Postgresql valutation for the company where I work
> and I learned that
> with 250 MB you can open up to  80 concurrent query
> with 500 MB you can open up to 120 concurrent query
> from now on for each 250MB you can have ~40 connections more

That does not add up: the graph can't have a negative y-intercept.
There should be a substantial cost to run the postmaster at all,
and then an essentially fixed cost per connection --- assuming
that all the connections are running similar queries, of course.
You're telling us the first 40 connections require zero RAM.

            regards, tom lane

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

Предыдущее
От: Vikram
Дата:
Сообщение: Re: postgres in freebsd jail
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: Thousands of parallel connections