Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] json(b)_array_elements use causes very large memory usage when also referencing entire json document - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] json(b)_array_elements use causes very large memory usage when also referencing entire json document
Date
Msg-id 7739.1507343737@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] json(b)_array_elements use causes very large memory usagewhen also referencing entire json document  (Andres Freund <andres@anarazel.de>)
Responses Re: [BUGS] json(b)_array_elements use causes very large memory usagewhen also referencing entire json document  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
Tree view 
Andres Freund <andres@anarazel.de> writes:
> I've just played around with this. ValuePerCall SRFs are fine with
> called in a short-lived context (they're required to be able to, as
> documented in xfunc.sgml), so is SFRM_Materialize. The only thing to be
> careful about is the *arguments* to the function, those need to live
> long enough in the ValuePerCall case.

Isn't there already code to deal with that?  See around line 175
in execSRF.c.
        regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: [BUGS] json(b)_array_elements use causes very large memory usagewhen also referencing entire json document
Next
From: Andres Freund
Date:
Subject: Re: [BUGS] json(b)_array_elements use causes very large memory usagewhen also referencing entire json document