Re: Kernel kills postgres process - help need

Tom,

Le mercredi 9 janvier 2008, Tom Lane a écrit :
> =?utf-8?q?Herv=C3=A9_Piedvache?= <bill(dot)footcow(at)gmail(dot)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 ...
>
> 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