Re: possible memory leak with SRFs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: possible memory leak with SRFs
Date
Msg-id 2870.1273327266@sss.pgh.pa.us
Whole thread Raw
In response to Re: possible memory leak with SRFs  (Nikhil Sontakke <nikhil.sontakke@enterprisedb.com>)
List pgsql-hackers
Nikhil Sontakke <nikhil.sontakke@enterprisedb.com> writes:
> Ok thanks. So if someone uses a really long-running srf with argument
> expression evaluations thrown in, then running into "out of memory"
> issues should be expected and then in those cases they are better off
> using multiple srf calls to get the same effect if they can..

I believe this is only an issue for SRFs called in a query targetlist,
which is a usage fraught with semantic problems anyway.  Hopefully we
can get LATERAL done soon (I'm planning to look at it for 9.1) and
then deprecate this whole mess.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] psql weird behaviour with charset encodings
Next
From: Joe Conway
Date:
Subject: Re: possible memory leak with SRFs