Postgres Pro
Downloads
Home   >   mailing lists

Re: unconstrained memory growth in long running procedure stored procedure after upgrading 11-12 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: unconstrained memory growth in long running procedure stored procedure after upgrading 11-12
Date
Msg-id 3070324.1617149662@sss.pgh.pa.us
Whole thread Raw
In response to Re: unconstrained memory growth in long running procedure stored procedure after upgrading 11-12  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: unconstrained memory growth in long running procedure stored procedure after upgrading 11-12
List pgsql-hackers
Tree view 
Justin Pryzby <pryzby@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.

            regards, tom lane

pgsql-hackers by date:

Previous
From: "'alvherre@alvh.no-ip.org'"
Date:
Subject: Re: libpq debug log
Next
From: Joe Conway
Date:
Subject: Re: "has_column_privilege()" issue with attnums and non-existent columns