| From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Duncan Sands <duncan(dot)sands(at)deepbluecap(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Unlimited memory consumption with long-lived connection |
| Date: | 2023-02-22 19:12:22 |
| Message-ID: | 20230222191221.GE1653@telsasoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wed, Feb 22, 2023 at 10:28:11AM -0800, Andres Freund wrote:
> On 2023-02-22 08:53:41 -0600, Justin Pryzby wrote:
> > There are patches proposed here, which fixed the issue for me.
> > But I've always been suspicious that there may be a 2nd, undiagnosed
> > issue lurking behind this one...
>
> Any more details?
No. My suspicion is because the process is killed by OOM roughly every
24h, and the leak didn't seem to be big enough to cause that.
Maybe the leak is nonlinear or not completely deterministic or something
sometimes exacerbates the original issue, or maybe there's only one
issue that's 90% but not 100% understood, or maybe there's a 2nd issue
that's latent once the fix is applied for the known issue.
There's also this report:
https://www.postgresql.org/message-id/1605804350439-0.post%40n3.nabble.com
..which offers no details or reponse, and could easily be a leak in
someting other than JIT, or postgres, or not a leak at all.
--
Justin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2023-02-22 19:23:50 | Re: BUG #17800: ON CONFLICT DO UPDATE fails to detect incompatible fields that leads to a server crash |
| Previous Message | Andres Freund | 2023-02-22 18:28:11 | Re: Unlimited memory consumption with long-lived connection |