Thanks Alvaro for your answer really clear.
Another, may be stupid question, but when you have several web nodes like
me ... with several physical database (I'm not talking about replication,
it's just that the web node can contact 3 or 4 differents database for
differents applications), what is the best way to process with a pooler ...
install one on each node or one on each database ?
Regards,
Le jeudi 7 février 2008, Alvaro Herrera a écrit :
> Hervé Piedvache escribió:
> > Tom,
> >
> > Le mercredi 9 janvier 2008, Tom Lane a écrit :
> > > =?utf-8?q?Herv=C3=A9_Piedvache?= <bill.footcow@gmail.com> writes:
> > > > When I have a lot of connexions (persistante connexions from 6 web
> > > > apache/php serveurs using PDO, about 110 process on each web servers)
> > > > on the server, or long request, it's difficult for me to know when
> > > > it's appening, the kernel seems to kill my postgresql process then
> > > > the server become completly instable, and most of the time need a
> > > > reboot ...
> > >
> > > Have you considered using a connection pooler in front of a smaller
> > > number of backends?
> >
> > You never answered me to this point ... we use persistants connections so
> > I don't understand the interest of using a pooler ...
>
> The problem with persistent connections is that they are, well,
> persistent -- so they keep resources allocated, which the server cannot
> then use for other things. The PHP model of persistent connections is
> silly and useless, because each PHP process keeps an open connection (or
> more than one, if it connects to different databases), which is then
> idle most of the time.
>
> A pooler also keeps the connections open, but they are given in turns to
> different PHP processes as they need them. The total number of open
> connections to the database server is lower, which leads to resource
> wastage being lower.
>
> > Otherwise, what pooler do you recommand, and what will be the improvement
> > for us ?
>
> The two most recommended ones I've seen around here are pgbouncer and
> pgpool. I think pgbouncer is supposed to perform better, at the cost of
> not having certain bells and whistles (which you may not need anyway).
--
Hervé Piedvache
Elma Ingénierie Informatique
Groupe Maximiles S.A.
3 rue d'Uzès
F-75002 - Paris - France
Pho. 33-144949901
Fax. 33-144882747