Re: Abnormally high memory usage/OOM triggered

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Abnormally high memory usage/OOM triggered
Дата
Msg-id 3138.1516234520@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Abnormally high memory usage/OOM triggered  (Davlet Panech <dpanech@gmail.com>)
Список pgsql-admin
Davlet Panech <dpanech@gmail.com> writes:
> I'm troubleshooting a problem with a Postgres installation (Linux): a 
> client process got killed by OOM while executing an update statement, 
> Is there a memory leak in there somewhere?
> I'm using Postgres 9.4.8 on x86_64-redhat-linux-gnu with 16GB of 
> physical RAM and 8GB of swap space.

I see a possibly relevant entry in the 9.4.10 release notes:

      Fix query-lifespan memory leak in a bulk UPDATE on a table
      with a PRIMARY KEY or REPLICA IDENTITY index

Looking at the relevant commit (ae4760d66), it seems the leak was
just a few bytes per row, but if the update touches enough rows ...

            regards, tom lane


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

Предыдущее
От: scott ribe
Дата:
Сообщение: Re: Abnormally high memory usage/OOM triggered
Следующее
От: Ashwani Kumar B
Дата:
Сообщение: Starting Postgre DB in read write mode