Re: BUG #15700: PG 10 vs. 11: Large increase in memory usage when selecting BYTEA data (maybe memory leak)

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Matthias Otterbach <mo(at)otterbach(dot)eu>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15700: PG 10 vs. 11: Large increase in memory usage when selecting BYTEA data (maybe memory leak)
Date: 2019-03-18 20:44:02
Message-ID: CAMkU=1x_XySqXZ-1gCyoaipKLzefQSr1BuaHL12vy_9WKFnjYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Mar 18, 2019 at 2:50 PM Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:

>
> Doing that, I can reproduce the problem, and it seems to be using an
> implicitly declared cursor (which I have not run into before).
>
>
The culprit is f2dec34e19d3969ddd6. Also, it doesn't depend on bytea, it
leaks for text as well.

I looked at the patch and nothing in jumps out to me as causing a leak.

commit f2dec34e19d3969ddd616e671fe9a7b968bec812
Author: Andres Freund <andres(at)anarazel(dot)de>
Date: Wed Oct 11 16:26:35 2017 -0700

Use one stringbuffer for all rows printed in printtup.c.

Cheers,

Jeff

>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2019-03-18 20:53:07 Re: BUG #15700: PG 10 vs. 11: Large increase in memory usage when selecting BYTEA data (maybe memory leak)
Previous Message Tom Lane 2019-03-18 20:16:47 Re: BUG #15700: PG 10 vs. 11: Large increase in memory usage when selecting BYTEA data (maybe memory leak)