
psql postgres <<EOF

drop table if exists gist_point_tbl;
drop sequence if exists gist_test_seq;

create sequence gist_test_seq;
create table gist_point_tbl(id int4, p point) with (autovacuum_enabled=false);
create index gist_pointidx on gist_point_tbl using gist(p);
EOF

for ((i = 1; i < 100; i++))
do
  psql postgres <<EOF
insert into gist_point_tbl (id, p)
    select nextval('gist_test_seq'), point(nextval('gist_test_seq'), 
1000 + g) from generate_series(1, 10000) g;

delete from gist_point_tbl where id < currval('gist_test_seq') - 20000;
vacuum gist_point_tbl;

select pg_table_size('gist_point_tbl'), pg_indexes_size('gist_point_tbl');
EOF
done
  
# Induce wraparound

for ((i = 1; i < 230; i++))
do
  psql postgres -c "select consume_xids(10000000)"
done

for ((i = 1; i < 100; i++))
do
  psql postgres <<EOF
insert into gist_point_tbl (id, p)
    select nextval('gist_test_seq'), point(nextval('gist_test_seq'), 
1000 + g) from generate_series(1, 10000) g;

delete from gist_point_tbl where id < currval('gist_test_seq') - 20000;
vacuum gist_point_tbl;

select pg_table_size('gist_point_tbl'), pg_indexes_size('gist_point_tbl');
EOF
done
