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

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.
        regards, tom lane