CREATE TABLE test1 ( id serial not null primary key, value1 int not null default 10, value1_enabled boolean not null default true, value2 int not null default 10, value2_enabled boolean not null default true, value3 int not null default 10, value3_enabled boolean not null default true, value4 int not null default 10, value4_enabled boolean not null default true, value5 int not null default 10, value5_enabled boolean not null default true, value6 int not null default 10, value6_enabled boolean not null default true, value7 int not null default 10, value7_enabled boolean not null default true, value8 int not null default 10, value8_enabled boolean not null default true, value9 int not null default 10, value9_enabled boolean not null default true, value10 int not null default 10, value10_enabled boolean not null default true ); CREATE TABLE test2 ( id serial not null primary key, value1 int not null default 10, value2 int not null default 10, value3 int not null default 10, value4 int not null default 10, value5 int not null default 10, value6 int not null default 10, value7 int not null default 10, value8 int not null default 10, value9 int not null default 10, value10 int not null default 10, value1_enabled boolean not null default true, value2_enabled boolean not null default true, value3_enabled boolean not null default true, value4_enabled boolean not null default true, value5_enabled boolean not null default true, value6_enabled boolean not null default true, value7_enabled boolean not null default true, value8_enabled boolean not null default true, value9_enabled boolean not null default true, value10_enabled boolean not null default true ); insert into test1 (value1) select x.x from generate_series(1,1000000) x(x); insert into test2 (value1) select x.x from generate_series(1,1000000) x(x); postgres=# select pg_size_pretty(pg_relation_size('test2')); pg_size_pretty ---------------- 81 MB (1 row) postgres=# select pg_size_pretty(pg_relation_size('test1')); pg_size_pretty ---------------- 112 MB (1 row) postgres=# select sum(Value1) from test1; sum -------------- 500000500000 (1 row) Time: 239.306 ms postgres=# select sum(Value1) from test2; sum -------------- 500000500000 (1 row) Time: 186.926 ms