Problem with Out of Memory and no more connecction possible

Поиск
Список
Период
Сортировка
От AL-Temimi, Muthana
Тема Problem with Out of Memory and no more connecction possible
Дата
Msg-id 24F2E095E199B041912675E4E3BBA011B0978E83@WEXCPPA018.fhhnet.stadt.hamburg.de
обсуждение исходный текст
Ответы Re: Problem with Out of Memory and no more connecction possible  (Dmitrii Golub <dmitrii.golub@gmail.com>)
Re: Problem with Out of Memory and no more connecction possible  (lst_hoe02@kwsoft.de)
Список pgsql-admin

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 по дате отправления:

Предыдущее
От: Greg Clough
Дата:
Сообщение: Re: replication consistency checking
Следующее
От: Dmitrii Golub
Дата:
Сообщение: Re: Problem with Out of Memory and no more connecction possible