Re: Thousands of parallel connections - Mailing list pgsql-general

From Tom Lane
Subject Re: Thousands of parallel connections
Date
Msg-id 18392.1092697736@sss.pgh.pa.us
Whole thread Raw
In response to Re: Thousands of parallel connections  (Gaetano Mendola <mendola@bigfoot.com>)
Responses Re: Thousands of parallel connections  (Gaetano Mendola <mendola@bigfoot.com>)
Re: Thousands of parallel connections  (Chris Travers <chris@metatrontech.com>)
List 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 by date:

Previous
From: Vikram
Date:
Subject: Re: postgres in freebsd jail
Next
From: Gaetano Mendola
Date:
Subject: Re: Thousands of parallel connections