Skip site navigation (1) Skip section navigation (2)

Re: Memory usage of writer process

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Alex <alex(at)liivid(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Memory usage of writer process
Date: 2009-08-13 20:29:44
Message-ID: 20090813202944.GT5909@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-performance
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.

In response to

Responses

pgsql-performance by date

Next:From: Alex NethDate: 2009-08-13 21:01:26
Subject: Re: Memory usage of writer process
Previous:From: Richard HuxtonDate: 2009-08-13 16:28:01
Subject: Re: Under the hood of views

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group