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