heiiki10.sql

text/plain

Filename: heiiki10.sql

Type: text/plain

Part: 1

Message: Re: making update/delete of inheritance trees scale better

drop table tab;
create unlogged table tab (a int4, b int4, f3 int, f4 int, f5 text, f6 float8);
\timing on
insert into tab select g, g, g, g, g::text, g from generate_series(1, 10000000) g;
vacuum tab;
explain update tab set b = b, a = a;
update tab set b = b, a = a;