On Fri, Aug 30, 2013 at 2:10 AM, 高健 <luckyjackgao@xxxxxxxxx> wrote: > > > postgres=# insert into test01 values(generate_series(1,2457600),repeat( > chr(int4(random()*26)+65),1024)); The construct "values (srf1,srf2)" will generate its entire result set in memory up front, it will not "stream" its results to the insert statement on the fly. To spare memory, you would want to use something like: insert into test01 select generate_series, repeat(chr(int4(random()*26)+65),1024) from generate_series(1,2457600); Cheers, Jeff -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
