Re: Memory usage of writer process

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(at)commandprompt(dot)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