From: Tom Lane <tgl@sss.pgh.pa.us>
To: Gunther <raj@gusw.net>
cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>,
        Justin Pryzby <pryzby@telsasoft.com>,
        Jeff Janes <jeff.janes@gmail.com>,
        pgsql-performance@lists.postgresql.org,
        Alvaro Herrera <alvherre@2ndquadrant.com>
Subject: Re: Out of Memory errors are frustrating as heck!
In-reply-to: <7ed3d2a0-0a1d-0bd2-5417-9b69038abfcf@gusw.net>
References: <20190421161434.4hedytsadpbnglgk@development>
 <19198.1555857403@sss.pgh.pa.us> <20190421164022.GD14223@telsasoft.com>
 <20190422030927.3huxq7gghms4kmf4@development>
 <2d422e7e-3105-3320-f3d5-801bd6a8b27d@gusw.net>
 <20190423204348.GJ3925@telsasoft.com>
 <f61f61d1-fbd6-2bbd-a4b9-7591ad18dde5@gusw.net>
 <20190424003633.ruvhbv5ro3fawo67@development>
 <20190428141901.5dsbge2ka3rxmpk6@development>
 <7ed3d2a0-0a1d-0bd2-5417-9b69038abfcf@gusw.net>
Comments: In-reply-to Gunther <raj@gusw.net>
	message dated "Fri, 23 Aug 2019 09:17:38 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <26355.1566570031.1@sss.pgh.pa.us>
Date: Fri, 23 Aug 2019 10:20:31 -0400
Message-ID: <26356.1566570031@sss.pgh.pa.us>
Precedence: bulk

Gunther <raj@gusw.net> writes:
> Hi all, I am connecting to a discussion back from April this year. My 
> data has grown and now I am running into new out of memory situations. 

It doesn't look like this has much of anything to do with the hash-table
discussion.  The big hog is an ExprContext:

> ExprContext: 1107296256 total in 142 blocks; 6328 free (101 chunks); 
> 1107289928 used

So there's something leaking in there, but this isn't enough info
to guess what.

			regards, tom lane