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

From Chris Travers
Subject Re: Thousands of parallel connections
Date
Msg-id 41215033.2050909@metatrontech.com
Whole thread Raw
In response to Re: Thousands of parallel connections  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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
>
>
>
>


Attachment

pgsql-general by date:

Previous
From: s post
Date:
Subject: unserializable transaction?
Next
From: Chris Travers
Date:
Subject: Re: psql - user defined SQL variables