Re: Keeping processes open for re-use

[Richard Huxton <dev(at)archonet(dot)com>]

Jean-Max Reymond wrote:
> 2006/11/10, Joshua D. Drake <jd(at)commandprompt(dot)com>:
> > I would actually suggest pg_pool over pg_pconnect.
>
> Please, can you explain advantages of pg_pool over pg_connect ?

He said pg_pconnect (note the extra "p"). This provides permanent 
connections to the database from PHP. However, you will end up with one 
connection per Apache process running (without running multiple Apache 
setups to serve different content types). Since many processes will be 
serving images or static content you have a lot of wasted, idle, 
connections.

Now, pg_pool allows you to maintain a small number of active connections 
(say 20 or 50) and have PHP connect to your pgpool server. It allocates 
the next free connection it holds and so lets you minimise the number of 
connections to PostgreSQL.

HTH
--
  Richard Huxton
  Archonet Ltd