Postgres Pro
Downloads
Home   >   mailing lists

Problem with Out of Memory and no more connecction possible - Mailing list pgsql-admin

From AL-Temimi, Muthana
Subject Problem with Out of Memory and no more connecction possible
Date
Msg-id 24F2E095E199B041912675E4E3BBA011B0978E83@WEXCPPA018.fhhnet.stadt.hamburg.de
Whole thread Raw
Responses Re: Problem with Out of Memory and no more connecction possible
Re: Problem with Out of Memory and no more connecction possible
List pgsql-admin
Tree view

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.al@tu-harburg.de

http://www.tu-harburg.de/rzt

 

 

pgsql-admin by date:

Previous
From: Greg Clough
Date:
Subject: Re: replication consistency checking
Next
From: Dmitrii Golub
Date:
Subject: Re: Problem with Out of Memory and no more connecction possible