Search Postgresql Archives

Re: about memory size reported by system.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Title: RE: about memory size reported by system.

Are you using any connection pooling system, if not look at the pgpool & pgbouncer.

open connections always reserves memory, which slowdown the performance of system.

you can also handle application connections at application level by defining garbage
value if any connection disconnect. It will release the memory reserved by connection. 


--
Thanks & Regards
Dhaval Jaiswal


-----Original Message-----
From: pgsql-general-owner@xxxxxxxxxxxxxx on behalf of Edmundo Robles L.
Sent: Wed 3/9/2011 10:12 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: about memory size  reported by system.

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 have 50 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.





--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. 
Any review, re-transmission, dissemination or other use of or taking of any action in reliance upon,this information by persons or entities other than the intended recipient is prohibited. 
If you received this in error, please contact the sender and delete the material from your computer. 
Microland takes all reasonable steps to ensure that its electronic communications are free from viruses. 
However, given Internet accessibility, the Company cannot accept liability for any virus introduced by this e-mail or any attachment and you are advised to use up-to-date virus checking software. 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux