about memory size reported by system. - Mailing list pgsql-general

From Edmundo Robles L.
Subject about memory size reported by system.
Date
Msg-id 252EE06031407243B058CF7699226E3A01D42A29@mail2.sensacd.com.mx
Whole thread Raw
Responses Re: about memory size reported by system.
List pgsql-general
Hi everyone!

I have a doubt about  the memory consumed by  each connection open.

suddenly my server, running postgres 8.3.11,  began to run   too slowly.

Checking the  process with: ps -adelfo pcpu,vsz,args | more

The processes,related to the connection to the db, each one  have a consume of memory near to the 50Mb. by the way i
have50 connections to the db, so i have a reported  memory consumed of 2.5M, when i have only 1G in the server. 

If  I modify the shared_buffers value,  the report of  memory consumed  is according  with  shared buffers value.



Should I worry by that?
There is a  best way to tweak  the memory consumed by postgres?

--
SENSA Control Digital.
Ing. Edmundo Robles Lopez.
Analista Programador.





pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to configure for remote TCP/IP client conncections using MS Visual Basic OLE DB calls and PostgreSQL dll's?
Next
From: Reece Hart
Date:
Subject: Re: equivalent of mysql's SET type?