Hi, Thanks for the answer ...
But honestly I think that was a misunderstood. The memory increase issue is showed in the DATA column. Look how day by day it increases exponencially. In a few days PostGres goes out of memory, close the connections and enter in a recovery mode. I really don’t know what is causing it. Date 29/06/2009 top - 07:58:49 up 21 days, 7:47, 1 user, load average: 0.73, 0.74, 0.71 Tasks: 131 total, 1 running, 129 sleeping, 0 stopped, 1 zombie Cpu(s): 13.2% us, 1.3% sy, 0.0% ni, 83.1% id, 1.9% wa, 0.2% hi, 0.2% si Mem: 4107392k total, 3764272k used, 343120k free, 24760k buffers Swap: 2031608k total, 592k used, 2031016k free, 3522224k cached PID USER PR NI VIRT SWAP RES SHR DATA CODE S %CPU %MEM TIME+ COMMAND 9943 postgres 15 0 860m 41m 819m 811m 9604 3540 D 88.3 20.4 0:08.33 postgres: dbtest test 10.255.100.73(4796) SELECT 32731 postgres 16 0 854m 741m 112m 109m 3880 3540 S 12.9 2.8 11:52.47 postgres: dbtest test 10.255.100.65(57470) idle Date 29/06/2009 top - 10:37:11 up 21 days, 10:25, 1 user, load average: 1.50, 1.60, 1.46 Tasks: 130 total, 3 running, 126 sleeping, 0 stopped, 1 zombie Cpu(s): 13.3% us, 1.2% sy, 0.0% ni, 84.4% id, 0.7% wa, 0.2% hi, 0.2% si Mem: 4107392k total, 4103184k used, 4208k free, 49036k buffers Swap: 2031608k total, 592k used, 2031016k free, 3698156k cached PID USER PR NI VIRT SWAP RES SHR DATA CODE S %CPU %MEM TIME+ COMMAND 9943 postgres 15 0 994m 33m 960m 818m 143m 3540 S 29.5 23.9 48:19.96 postgres: dbtest test 10.255.100.73(4796) idle 32731 postgres 16 0 854m 666m 188m 184m 3888 3540 R 25.5 4.7 25:03.44 postgres: dbtest test 10.255.100.65(57470) PARSE Date 29/06/2009 top - 19:05:03 up 21 days, 18:53, 1 user, load average: 0.95, 0.91, 0.90 Tasks: 131 total, 1 running, 129 sleeping, 0 stopped, 1 zombie Cpu(s): 9.2% us, 0.5% sy, 0.0% ni, 88.7% id, 1.2% wa, 0.3% hi, 0.2% si Mem: 4107392k total, 4094680k used, 12712k free, 18320k buffers Swap: 2031608k total, 592k used, 2031016k free, 3331036k cached PID USER PR NI VIRT RES SHR CODE DATA S %CPU %MEM TIME+ COMMAND 9943 postgres 16 0 1366m 1.3g 818m 3540 515m S 31.2 33.2 192:20.61 postgres: dbtest test 10.255.100.73(4796) SELECT 32731 postgres 16 0 853m 305m 302m 3540 3176 S 0.0 7.6 47:38.95 postgres: dbtest test 10.255.100.65(57470) idle Date 30/06/2009 top - 07:41:43 up 22 days, 7:30, 1 user, load average: 0.60, 0.75, 1.16 Tasks: 136 total, 2 running, 133 sleeping, 0 stopped, 1 zombie Cpu(s): 6.6% us, 0.9% sy, 0.0% ni, 91.7% id, 0.3% wa, 0.3% hi, 0.2% si Mem: 4107392k total, 4101088k used, 6304k free, 18480k buffers Swap: 2031608k total, 592k used, 2031016k free, 2971740k cached PID USER PR NI VIRT SWAP RES SHR DATA CODE S %CPU %MEM TIME+ COMMAND 9943 postgres 17 0 1724m 30m 1.7g 821m 873m 3540 R 27.2 42.2 325:54.83 postgres: citgis citgis 10.255.100.73(4796) SELECT 32731 postgres 16 0 853m 500m 353m 350m 2980 3540 S 0.0 8.8 61:25.21 postgres: citgis citgis 10.255.100.65(57470) idle 2009/6/30 Scott Marlowe <scott.marl...@gmail.com> > On Mon, Jun 29, 2009 at 6:14 PM, Anderson Valadares<anderva...@gmail.com> > wrote: > > Hi all > > I have a software developed in Delphi as a Windows Service, but, i don't > > know why, it consumns an unexpected large system memory (515m). > > The service access PostgresSQL by ODBC driver (psqlodbc_08_03_0400) and > it > > consist simply of a loop calling a procedure PL/PGSQL. How to discover > what > > is causing or why this high memory usage ? What objects are being used on > > this session ? > > > PID USER PR NI VIRT SWAP RES SHR DATA CODE S %CPU %MEM > TIME+ > > COMMAND > > 9943 postgres 15 0 860m 41m 819m 811m 9604 3540 D 88.3 20.4 > 0:08.33 > > postgres: dbtest test 10.255.100.73(4796) SELECT > > 32731 postgres 16 0 854m 741m 112m 109m 3880 3540 S 12.9 2.8 > 11:52.47 > > postgres: dbtest test 10.255.100.65(57470) idle > > Generally speaking, the actual delta for memory usage is the res - > shared memory, which puts both of those backends at using an > individual amount of memory at somewhere in the 5 to 8 meg range. The > rest is shared memory, including shared_buffers and such. > > Seeing as you say your shared_buffers is 512M, I'm not sure where the > rest of the shared memory is coming from here in top. > > > Mem: 4107392k total, 4103184k used, 4208k free, 49036k buffers > > Swap: 2031608k total, 592k used, 2031016k free, 3698156k cached > > Note that your machine is still showing 3.6G or so used for caching > our of 4G, so you're only using an actual amount of about 400 Meg > > Are you having any measurable performance issues, or just curious / > worried about what seems like high memory usage? Your numbers look > pretty normal to me otherwise. >
