Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document

From: Lucas Fairchild-Madar <lucas(dot)madar(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document
Date: 2017-10-06 18:45:07
Message-ID: CAJmoq7OmXJ_G87D_He5j9kRSraANsuV7Oatxg3bhMsuawvOJ3Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Oct 6, 2017 at 11:30 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Lucas Fairchild-Madar <lucas(dot)madar(at)gmail(dot)com> writes:
> > This might be related to or a duplicate of: BUG #14843: CREATE TABLE
> churns
> > through all memory
>
> Yeah, sounds like it. Can you check if the just-committed patch
> fixes it?
>
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=
> 0c25e9652461c08b5caef259a6af27a38707e07a
>
>
I'm experiencing this on 9.6. Can't figure out where this patch applies
there.

In the meantime, I'll try to reproduce on 10 and see what happens.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-10-06 18:48:54 Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document
Previous Message Tom Lane 2017-10-06 18:30:35 Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document