Re: increasing database connections

From: Florian Weimer
Subject: Re: increasing database connections
Date: ,
Msg-id: 82d53t8bto.fsf@mid.bfk.de
(view: Whole thread, Raw)
In response to: Re: increasing database connections  (Mark Kirkwood)
List: pgsql-performance

Tree view

increasing database connections  (Shiva Sarna, )
 Re: increasing database connections  ("Jonah H. Harris", )
  Re: increasing database connections  ("Joshua D. Drake", )
   Re: increasing database connections  (Mark Kirkwood, )
    Re: increasing database connections  (Florian Weimer, )
   Re: increasing database connections  (Ron, )
  Re: increasing database connections  (Magnus Hagander, )
   Re: increasing database connections  ("Joshua D. Drake", )

* 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                <>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99


pgsql-performance by date:

From: "Joshua D. Drake"
Date:
Subject: Re: increasing database connections
From: Stephan Szabo
Date:
Subject: Re: Identical Queries