Postgres Pro
Downloads
Home   >   mailing lists

Re: Abnormally high memory usage/OOM triggered - Mailing list pgsql-admin

From Tom Lane
Subject Re: Abnormally high memory usage/OOM triggered
Date
Msg-id 3138.1516234520@sss.pgh.pa.us
Whole thread Raw
In response to Abnormally high memory usage/OOM triggered  (Davlet Panech <dpanech@gmail.com>)
List pgsql-admin
Tree view 
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 by date:

Previous
From: scott ribe
Date:
Subject: Re: Abnormally high memory usage/OOM triggered
Next
From: Ashwani Kumar B
Date:
Subject: Starting Postgre DB in read write mode