* John R Pierce (pierce@xxxxxxxxxxxx) wrote: > 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. As Tom points out, it's really PG that makes the new connections slow; fork(), while it can be slow on some platforms, really is small potatos compared to PG opening a database, populating caches, etc. Thanks, Stephen
Attachment:
signature.asc
Description: Digital signature
