Re: Abnormally high memory usage/OOM triggered

Davlet Panech  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