clog_stress.sql

text/x-sql

Filename: clog_stress.sql

Type: text/x-sql

Part: 1

Message: How much do the hint bits help?

truncate deltest;

select 
replace($$insert into deltest select generate_series(%val%, %val% + 9999); 
delete from deltest where v between %val% and %val% + 9999 and v % 2 = 0;
vacuum deltest;
$$, '%val%', (v * 10000)::text) from generate_series(0,350) v;