2010/6/30 Thom Brown <thombr...@gmail.com> > On 30 June 2010 19:43, Joshua D. Drake <j...@commandprompt.com> wrote: > > On Wed, 2010-06-30 at 20:42 +0200, Szymon Guz wrote: > >> Hi, > >> in a PHP application working on Postgres normally the new connection > >> to the database is made per request. > >> > >> > >> This can potentially cause too big overhead, so I've got some > >> questions: > >> > >> > >> - is the overhead really noticeable? > > > > It can be. > > > >> - could this be solved using persistent connections, or the persistent > >> connections in php and postgres don't work properly? > > > > Don't use them. > > > >> - could this be solved using something like pgpool? > >> > > Yes, using a connection pooler will solve the problem. I prefer > > pgbouncer. > > > > +1 > > I can't really add to that. > > Thom >
Thanks for the answers that ensured me in what I was thinking about. regards Szymon
