The writer process seems to be using inordinate amounts of memory:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+
11088 postgres 13 -2 3217m 2.9g 2.9g S 0 38.7 0:10.46 postgres:
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?
pgsql-performance by date
|Next:||From: Rstat||Date: 2009-08-13 09:22:28|
|Subject: Less expensive proprietary or Open source ETL tools|
|Previous:||From: Robert Haas||Date: 2009-08-12 23:49:00|
|Subject: Re: Why is vacuum_freeze_min_age 100m?|