On Tue, Jun 3, 2014 at 03:59:45PM -0400, Tom Lane wrote: > Soroosh Sardari <[email protected]> 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 <[email protected]> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
