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@commandprompt.com> 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