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

Memory usage of writer process

From: Alex <alex(at)liivid(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Memory usage of writer process
Date: 2009-08-13 04:44:20
Message-ID: 73f5d8f0-ec4b-4643-b515-ec50b0a40f31@d15g2000prc.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-performance
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?


Responses

pgsql-performance by date

Next:From: RstatDate: 2009-08-13 09:22:28
Subject: Less expensive proprietary or Open source ETL tools
Previous:From: Robert HaasDate: 2009-08-12 23:49:00
Subject: Re: Why is vacuum_freeze_min_age 100m?

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