| From: | "Edmundo Robles L(dot)" <erobles(at)sensacd(dot)com(dot)mx> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | about memory size reported by system. |
| Date: | 2011-03-09 16:42:18 |
| Message-ID: | 252EE06031407243B058CF7699226E3A01D42A29@mail2.sensacd.com.mx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2011-03-09 16:53:14 | Re: How to configure for remote TCP/IP client conncections using MS Visual Basic OLE DB calls and PostgreSQL dll's? |
| Previous Message | John Edens | 2011-03-09 16:30:37 | How to configure for remote TCP/IP client conncections using MS Visual Basic OLE DB calls and PostgreSQL dll's? |