| From: | Florian Weimer <fweimer(at)bfk(dot)de> |
|---|---|
| To: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
| Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, Shiva Sarna <shivasarna(at)yahoo(dot)co(dot)in>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: increasing database connections |
| Date: | 2007-03-01 11:04:03 |
| Message-ID: | 82d53t8bto.fsf@mid.bfk.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
* Mark Kirkwood:
> Yeah - I thought that somewhere closer to 10000 connections is where
> you get hit with socket management related performance issues.
Huh? These sockets aren't handled in a single process, are they?
Nowadays, this number of sockets does not pose any problem for most
systems, especially if you don't do I/O multiplexing. Of course, if
you've got 10,000 connections which are active in parallel, most users
won't be content with 1/10,000th of your database performance. 8-/ (I
don't see why idle connections should be a problem from a socket
management POV, though.)
--
Florian Weimer <fweimer(at)bfk(dot)de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2007-03-01 12:20:55 | Re: increasing database connections |
| Previous Message | Ben Trewern | 2007-03-01 11:00:38 | Re: performances with Pentium D |