Soroosh Sardari <soroosh.sard...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers