two memory-consuming postgres processes

Поиск
Список
Период
Сортировка
От Alexy Khrabrov
Тема two memory-consuming postgres processes
Дата
Msg-id A728C858-76CF-473F-917B-3C9EA4AA75CF@gmail.com
обсуждение исходный текст
Ответы Re: two memory-consuming postgres processes
Re: two memory-consuming postgres processes
Список pgsql-performance
Greetings -- I have an UPDATE query updating a 100 million row table,
and allocate enough memory via shared_buffers=1500MB.  However, I see
two processes in top, the UPDATE process eating about 850 MB and the
writer process eating about 750 MB.  The box starts paging.   Why is
there the writer taking almost as much space as the UPDATE, and how
can I shrink it?

Cheers,
Alexy

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Pros and Cons of 8.3.1
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: two memory-consuming postgres processes