Re: Monitoring number of backends

On 10/22/2013 1:13 PM, andy wrote:
> No, actually, I don't think my connect overhead is huge.  My apache
> and postgres are on the same box, and it connects using unix socket.
> Perhaps if my apache on db were on different boxes it would be a problem.

each postgres connection, if you're not using a pool, requires a fork()
of the postgres process.  fork is inherently an expensive process,
especially for a moderately large and fairly complex piece of software
like postgresql.





--
john r pierce                                      37N 122W
somewhere on the middle of the left coast