sql_used.sql

text/plain

Filename: sql_used.sql

Type: text/plain

Part: 1

Message: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap [Review]

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;