From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Gunther <raj@gusw.net>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jeff Janes <jeff.janes@gmail.com>
Cc: pgsql-performance@lists.postgresql.org, Alvaro Herrera <alvherre@2ndquadrant.com>
Subject: Re: Out of Memory errors are frustrating as heck!
Date: Sun, 6 Oct 2019 23:11:31 +0200
Message-ID: <20191006211131.5qpvj5dfh6f4ybfq@development> (raw)
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tomas.vondra@2ndquadrant.com, raj@gusw.net, pryzby@telsasoft.com, tgl@sss.pgh.pa.us, jeff.janes@gmail.com, alvherre@2ndquadrant.com
Subject: Re: Out of Memory errors are frustrating as heck!
In-Reply-To: <20191006211131.5qpvj5dfh6f4ybfq@development>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox