Re: Memory deallocation after calling cast function - Mailing list pgsql-hackers

On Tue, Jun  3, 2014 at 03:59:45PM -0400, Tom Lane wrote:
> Soroosh Sardari <soroosh.sardari@gmail.com> writes:
> > I have problem with memory deallocation. look at the following queries
> 
> > 1- create table test01(a) as select generate_series(1,100000000)::int8 ;
> 
> Do it as, eg,
> 
> create table test01(a) as select g::int8 from generate_series(1,100000000) g;
> 
> SRFs in the SELECT targetlist tend to leak memory; this is not easily
> fixable, and nobody is likely to try hard considering the feature's on
> the edge of deprecation anyhow.

Uh, what is replacing SRFs?  CTEs?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +