Re: [HACKERS] Simmultanous Connections (fwd)

Karl DeBisschop writes:
 > Sounds like she may looking at postgres in PHP - at least PHP uses
 > that temporary and permanant connection concept.  My experience is
 > that PHP persistent connections are not worth it - the time to
 > establish a new connection is pretty small, and stale connections can
 > cause problems.
 > 
 > >   2. I saw in the Q&A that to run more than 32 simmultanous connects could
 > >   be a big drain on our re-
 > >       sources. Our  Linux boxes , in general, are Intel 166 to 500s, 128MG
 > >   of RAM and 6.2 to 13 GIG.
 > >       Can anyone tell me roughly how much resources per connection does
 > >   PostgreSQL use?
 > 
 > If an idle psql connection is left open, we're looking at about 1 MB
 > RAM plus 4MB swap on my linux box.
 > 
 > As I noted above, I'd generally recommend against persistent
 > connections when there are more than a few users.

  As an example, I have systems with 2 or 3 hundred simultaneos
connections and besides being short time connections it's impossible to
have 200 or 300 backends running at the same time.
  In this case, I had to create a proxy to use few connections. I have 
AF_INET and AF_UNIX versions.

  []'s

Mateus Cordeiro Inssa
---------------------
Linux User: 76186  Kernel: 2.3.36
ICQ (Licq): 15243895
---------------------
mateus@ifnet.com.br
mateus@cwb.fnn.net

Tue Jan 11 08:45:00 EDT 2000