Date: Sun, 6 Oct 2019 23:11:31 +0200
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Gunther <raj@gusw.net>
Cc: Justin Pryzby <pryzby@telsasoft.com>, Tom Lane <tgl@sss.pgh.pa.us>,
	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!
Message-ID: <20191006211131.5qpvj5dfh6f4ybfq@development>
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>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Disposition: inline
In-Reply-To: <7ed3d2a0-0a1d-0bd2-5417-9b69038abfcf@gusw.net>
User-Agent: NeoMutt/20180716
Precedence: bulk

On Fri, Aug 23, 2019 at 09:17:38AM -0400, Gunther wrote:
>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. 
>Meanwhile the world turned from 11.2 to 11.5 which I just installed 
>only to find the same out of memory error.
>

As Tom already said, this seems like a quite independent issue. Next
time it'd be better to share it in a new thread, not to mix it up with
the old discussion.

>Have any of the things discussed and proposed, especially this last 
>one by Tomas Vondra, been applied to the 11 releases? Should I try 
>these older patches from April?
>

Unfortunately, no. We're still discussing what would be the right fix
(it's rather tricky and the patches I shared were way too experimental
for that). But I'm pretty sure whatever we end up doing it's going to be
way too invasive for backpatch. I.e. the older branches will likely have
this issue until EOL.

regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services