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

From scott ribe
Subject Re: Abnormally high memory usage/OOM triggered
Date
Msg-id 5E0AB8DB-F13B-41BF-843A-FE64FBE9C097@elevated-dev.com
Whole thread Raw
In response to Abnormally high memory usage/OOM triggered  (Davlet Panech <dpanech@gmail.com>)
Responses Re: Abnormally high memory usage/OOM triggered
List pgsql-admin
On Jan 17, 2018, at 2:57 PM, Davlet Panech <dpanech@gmail.com> wrote:
>
> Does my configuration look reasonable? I just don't understand how it could possibly use up 19 GB of memory based on
theconfiguration below. Is there a memory leak in there somewhere? 

It does seem awfully high, but... An update can involve a join across multiple tables. Or an update can run a trigger
whichcan cascade. Either of those could result in an "accidental cross product" join, which can always blow up memory. 

--
Scott Ribe
https://www.linkedin.com/in/scottribe/
(303) 722-0567



pgsql-admin by date:

Previous
From: Davlet Panech
Date:
Subject: Abnormally high memory usage/OOM triggered
Next
From: Tom Lane
Date:
Subject: Re: Abnormally high memory usage/OOM triggered