| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Chris Travers <chris(at)metatrontech(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Thousands of parallel connections |
| Date: | 2004-08-17 00:32:08 |
| Message-ID: | 24083.1092702728@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Chris Travers <chris(at)metatrontech(dot)com> writes:
> Tom Lane wrote:
>> 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?
Well, if you have significant contention problems then the speed could
be worse than linear --- but he was talking about memory usage. AFAICS,
a backend doing a particular query should need X amount of RAM pretty
much independently of how many others there are. The only data structure
I can think of that would be impacted at all is QuerySnapshot, and at
4 bytes per sibling backend it's *way* down in the noise...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Travers | 2004-08-17 00:42:17 | Re: Thousands of parallel connections |
| Previous Message | Glen Parker | 2004-08-17 00:30:00 | pg_clog and pg_xlog empty, postgresql refuses to start |