From: | Hervé Piedvache <bill(dot)footcow(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: Kernel kills postgres process - help need |
Date: | 2008-01-09 22:38:31 |
Message-ID: | 200801092338.31293.bill.footcow@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom,
Le mercredi 09 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.
My sysctl.conf file looks like this :
kernel.shmmax= 941604096
kernel.sem = 250 32000 100 400
fs.file-max=655360
vm.overcommit_memory=2
vm.overcommit_ratio=30
> > max_connections = 2048
>
> Have you considered using a connection pooler in front of a smaller
> number of backends?
Which system do you recommand for this ?
> If you really need that many backends, it'd likely be a good idea to
> reduce max_files_per_process to perhaps 100 or so. If you manage
> to run the kernel out of filetable slots, all sorts of userland stuff
> is going to get very unhappy.
I'll try this ...
regards,
--
Hervé
From | Date | Subject | |
---|---|---|---|
Next Message | Hervé Piedvache | 2008-01-09 22:43:47 | Re: Kernel kills postgres process - help need |
Previous Message | Chris Browne | 2008-01-09 22:32:19 | Re: count(*) and bad design was: Experiences with extensibility |