Re: Thousands of parallel connections

Tom Lane wrote:

>Gaetano Mendola <mendola(at)bigfoot(dot)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(at)postgresql(dot)org
>
>
>
>