On Tue, Mar 30, 2021 at 7:14 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > > Justin Pryzby <pry...@telsasoft.com> writes: > > On Tue, Mar 30, 2021 at 04:17:03PM -0500, Merlin Moncure wrote: > >> We just upgraded from postgres 11 to 12.6 and our server is running > >> out of memory and rebooting about 1-2 times a day. > > > I haven't tried your test, but this sounds a lot like the issue I reported > > with > > JIT, which is enabled by default in v12. > > FWIW, I just finished failing to reproduce any problem with that > test case ... but I was using a non-JIT-enabled build.
Yep. Disabling jit (fully, fia jit=off, not what was suggested upthread) eliminated the issue, or at least highly mitigated the leak. I was using pgdg rpm packaging, which enables jit by default. Thanks everyone for looking at this, and the workaround is quick and easy. merlin
