Tom, Le mercredi 9 janvier 2008, Tom Lane a écrit : > =?utf-8?q?Herv=C3=A9_Piedvache?= <bill.footcow@xxxxxxxxx> 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 ... > > Turn off memory overcommit. > > > max_connections = 2048 > > 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 ... Otherwise, what pooler do you recommand, and what will be the improvement for us ? Thanks, -- 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
