Re: Thousands of parallel connections

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