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(at)ifnet(dot)com(dot)br
mateus(at)cwb(dot)fnn(dot)net

Tue Jan 11 08:45:00 EDT 2000