vacuum inittable; drop table if exists temptable; create UNLOGGED table temptable as select * from inittable where 1 != 1; select pg_prewarm('inittable', 'main', 'buffer', NULL, NULL); \timing insert into temptable select * from inittable; drop table if exists temptable;