drop table t1; create table t1 (id integer, num integer); create or replace function insert01() returns void as $$ begin for i in 1..10000 loop insert into t1 values(i, i * 2); end loop; return; end; $$ language plpgsql; select insert01();