From: | Hervé Piedvache <herve(at)elma(dot)fr> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org, Hervé Piedvache <bill(dot)footcow(at)gmail(dot)com> |
Subject: | Re: Kernel kills postgres process - help need |
Date: | 2008-02-07 09:53:51 |
Message-ID: | 200802071053.52096.herve@elma.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Samuel Reynaud | 2008-02-07 10:26:27 | Migration of /data from 32bit to 8.2 64bit |
Previous Message | Lawrence Oluyede | 2008-02-07 09:48:04 | PostgreSQL 8.3 XML parser seems not to recognize the DOCTYPE element in XML files |