Re: Thousands of parallel connections

Поиск
Список
Период
Сортировка
От Chris Travers
Тема Re: Thousands of parallel connections
Дата
Msg-id 41215033.2050909@metatrontech.com
обсуждение исходный текст
Ответ на Re: Thousands of parallel connections  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane wrote:

>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.
>
>
>
That is strange.  Is it really linear or does the cost go up somewhat
after the first few?

>            regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>
>


Вложения

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

Предыдущее
От: s post
Дата:
Сообщение: unserializable transaction?
Следующее
От: Chris Travers
Дата:
Сообщение: Re: psql - user defined SQL variables