Quick Links

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

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Lucas Fairchild-Madar <lucas(dot)madar(at)gmail(dot)com>
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:30:35
Message-ID:	1546.1507314635@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-bugs

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

regards, tom lane

In response to

json(b)_array_elements use causes very large memory usage when also referencing entire json document at 2017-10-06 18:26:35 from Lucas Fairchild-Madar

Responses

Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document at 2017-10-06 18:45:07 from Lucas Fairchild-Madar

Browse pgsql-bugs by date

	From	Date	Subject
Next Message	Lucas Fairchild-Madar	2017-10-06 18:45:07	Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document
Previous Message	Andres Freund	2017-10-06 18:27:15	Re: BUG #14843: CREATE TABLE churns through all memory, crashes db