Re: Monitoring number of backends - Mailing list pgsql-general

From John R Pierce
Subject Re: Monitoring number of backends
Date
Msg-id 5266E5E0.90609@hogranch.com
Whole thread Raw
In response to Re: Monitoring number of backends  (andy <andy@squeakycode.net>)
Responses Re: Monitoring number of backends  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Monitoring number of backends
Next
From: andy
Date:
Subject: Re: Monitoring number of backends