Memory usage of writer process

Поиск
Список
Период
Сортировка
От Alex
Тема Memory usage of writer process
Дата
Msg-id 73f5d8f0-ec4b-4643-b515-ec50b0a40f31@d15g2000prc.googlegroups.com
обсуждение исходный текст
Ответы Re: Memory usage of writer process  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Memory usage of writer process  (Scott Carey <scott@richrelevance.com>)
Memory reporting on CentOS Linux  (Jeremy Carroll <jeremy.carroll@networkedinsights.com>)
Список 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?


В списке pgsql-performance по дате отправления:

Предыдущее
От: Rstat
Дата:
Сообщение: Less expensive proprietary or Open source ETL tools
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Memory usage of writer process