Re: Memory usage of writer process

От: Alvaro Herrera
Тема: Re: Memory usage of writer process
Дата: ,
Msg-id: 20090813202944.GT5909@alvh.no-ip.org
(см: обсуждение, исходный текст)
Ответ на: Memory usage of writer process  (Alex)
Ответы: Re: Memory usage of writer process  (Alex Neth)
Список: pgsql-performance

Скрыть дерево обсуждения

Memory usage of writer process  (Alex, )
 Re: Memory usage of writer process  (Alvaro Herrera, )
  Re: Memory usage of writer process  (Alex Neth, )
 Re: Memory usage of writer process  (Scott Carey, )
 Memory reporting on CentOS Linux  (Jeremy Carroll, )
  Re: Memory reporting on CentOS Linux  (Reid Thompson, )
   Re: Memory reporting on CentOS Linux  (Jeremy Carroll, )
    Re: Memory reporting on CentOS Linux  (Scott Marlowe, )
   Re: Memory reporting on CentOS Linux  (Robert Haas, )
  Re: Memory reporting on CentOS Linux  (Scott Marlowe, )
  Re: Memory reporting on CentOS Linux  (Scott Carey, )
   Re: Memory reporting on CentOS Linux  (Jeremy Carroll, )
    Re: Memory reporting on CentOS Linux  (Tom Lane, )
     Re: Memory reporting on CentOS Linux  (Jeremy Carroll, )
      Re: Memory reporting on CentOS Linux  (Mark Mielke, )
       Re: Memory reporting on CentOS Linux  (Matthew Wakeling, )
        Re: Memory reporting on CentOS Linux  (Jeremy Carroll, )
         Re: Memory reporting on CentOS Linux  (Scott Carey, )
          Re: Memory reporting on CentOS Linux  (Scott Carey, )
   Re: Memory reporting on CentOS Linux  (Greg Smith, )

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.


В списке pgsql-performance по дате сообщения:

От: Greg Stark
Дата:
Сообщение: Re: Under the hood of views
От: Robert Haas
Дата:
Сообщение: Re: Why is vacuum_freeze_min_age 100m?