Re: Problem with Out of Memory and no more connecction possible

Hello,
It's well known behaviour, just use connection pooler

2015-06-05 0:35 GMT+03:00 AL-Temimi, Muthana <
muthana(dot)al-temimi(at)tu-harburg(dot)hamburg(dot)de>:

> Hello admins,
>
>
>
> i have postgresql version 9.1 and those my configurations:
>
>
>
> max_connection=600
>
> shared_buffers=1024M
>
> work_mem=4M
>
> and all others parameters are default as delivered with postgresql.
>
>
>
> I installed on Suse Enterprice Linux Server and kernel_shxmem= 2GByte in
> the sysctl.conf, because if I put 1Gbyte postgresql will never started.
>
> The total RAM of the server is 8GB.
>
>
>
> But when the active connections reach 300 then we get out of memory and I
> checked the system through “top” and I got 7,8GB used from 8GB and started
> to swap also. At the same time there are no new connection possible.
>
>
>
> I have connection pool pgpool II in the front of and the everything with
> it till now OK. No problem in the system and works fine.
>
>
>
> Any help will be grateful
>
>
>
> Best Regards
>
>
>
> Muthana AL-Temimi
>
> M.Sc. Informations- und Kommunikations-Systeme
>
>
>
> Technische Universitaet Hamburg Harburg
>
> -Rechenzentrum-
>
> Am Schwarzenberg-Campus 3
>
> D-21073 Hamburg
>
>
>
> Tel.: +49.40.42878.2338
>
> Fax.: +49.40.42793.5160
>
> E-Mail: m(dot)al(at)tu-harburg(dot)de
>
> http://www.tu-harburg.de/rzt
>
>
>
>
>