This is postgres 8.4 BTW. It says 2.9Gb of RESIDENT memory, that also seems to be shared. Is this the writer sharing the records it wrote in a shared buffer? PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 11088 postgres 13 -2 3217m 3.0g 3.0g S 0 39.5 0:14.23 postgres: writer process 968 postgres 14 -2 3219m 1.4g 1.4g S 0 18.8 4:37.57 postgres: cribq cribq [local] idle 24593 postgres 13 -2 3219m 331m 327m S 0 4.3 0:10.12 postgres: cribq cribq [local] idle 26181 postgres 13 -2 3219m 323m 319m S 0 4.2 0:06.48 postgres: cribq cribq [local] idle 12504 postgres 14 -2 3219m 297m 293m S 0 3.9 0:02.71 postgres: cribq cribq [local] idle 13565 postgres 14 -2 3219m 292m 288m S 0 3.8 0:02.75 postgres: cribq cribq [local] idle 623 postgres 13 -2 3219m 292m 287m S 0 3.8 0:02.28 postgres: cribq cribq [local] idle On Thu, Aug 13, 2009 at 1:29 PM, Alvaro Herrera<alvherre@xxxxxxxxxxxxxxxxx> wrote: > Alex wrote: >> The writer process seems to be using inordinate amounts of memory: >> >> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ >> COMMAND >> 11088 postgres 13 -2 3217m 2.9g 2.9g S 0 38.7 0:10.46 postgres: >> writer process >> 20190 postgres 13 -2 3219m 71m 68m S 0 0.9 0:52.48 postgres: >> cribq cribq [local] idle >> >> I am writing moderately large (~3k) records to my database a few times >> a second. Even when I stop doing that, the process continues to take >> up all of that memory. >> >> Am I reading this right? Why is it using so much memory? > > shared_buffers? > > -- > Alvaro Herrera http://www.CommandPrompt.com/ > The PostgreSQL Company - Command Prompt, Inc. > -- Alex Neth Liivid, Inc www.liivid.com +1 206 499 4995 +86 13761577188 Stephen Leacock - "I detest life-insurance agents: they always argue that I shall some day die, which is not so." - http://www.brainyquote.com/quotes/authors/s/stephen_leacock.html -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
