drop sequence t1_i_seq; drop table t1; create table t1 (i serial, t text); insert into t1(t) values(rpad('x',2048,'x')); insert into t1(t) values(rpad('x',2048,'x')); insert into t1(t) values(rpad('x',2048,'x')); insert into t1(t) values(rpad('x',2048,'x')); insert into t1(t) values(rpad('x',2048,'x')); insert into t1(t) values(rpad('x',2048,'x')); insert into t1(t) values(rpad('x',2048,'x')); insert into t1(t) values(rpad('x',2048,'x')); insert into t1(t) values(rpad('x',2048,'x')); insert into t1(t) values(rpad('x',3970,'x')); insert into t1(t) values(rpad('x',3970,'x')); insert into t1(t) values(rpad('x',3970,'x')); insert into t1(t) values(rpad('x',3970,'x')); insert into t1(t) values(rpad('x',2048,'x')); insert into t1(t) values(rpad('x',2048,'x')); insert into t1(t) values(rpad('x',2048,'x')); insert into t1(t) values(rpad('x',2048,'x')); insert into t1(t) values(rpad('x',2048,'x')); insert into t1(t) values(rpad('x',2048,'x')); insert into t1(t) values(rpad('x',3970,'x')); insert into t1(t) values(rpad('x',3970,'x')); insert into t1(t) values(rpad('x',3970,'x')); select ctid,i,char_length(t) from t1; delete from t1 where i = 1; delete from t1 where i = 4; delete from t1 where i = 7; delete from t1 where i = 10; delete from t1 where i = 11; delete from t1 where i = 12; delete from t1 where i = 13; delete from t1 where i = 14; delete from t1 where i = 15; delete from t1 where i = 16; select ctid,i,char_length(t) from t1; vacuum t1; select ctid,i,char_length(t) from t1; select version();