psql -c 'drop table if exists t'
psql -c 'create table t (i bigint);'
psql -c "CREATE INDEX ON t(right(i::text,1)) WHERE i::text LIKE '%1';"

while true
do
	psql -qXc "VACUUM FULL pg_toast.pg_toast_2619;"
	psql -qXc "VACUUM FULL pg_statistic;"
done &

while true
do
	psql -Xc "INSERT INTO t SELECT i FROM generate_series(1,999999) i"
	for a in `seq 999`
	do
		psql -Xc "ALTER TABLE t ALTER i TYPE int USING i::int"
		psql -Xc "ALTER TABLE t ALTER i TYPE bigint"
	done
	psql -Xc "TRUNCATE t"
done &

while true
do
#psql -Xc '\d t'
#	psql -Xc "SELECT c2.relname, i.indisprimary, i.indisunique, i.indisclustered, i.indisvalid, pg_catalog.pg_get_indexdef(i.indexrelid, 0, true), pg_catalog.pg_get_constraintdef(con.oid, true), contype, condeferrable, condeferred, i.indisreplident, c2.reltablespace FROM pg_catalog.pg_class c, pg_catalog.pg_class c2, pg_catalog.pg_index i LEFT JOIN pg_catalog.pg_constraint con ON (conrelid = i.indrelid AND conindid = i.indexrelid AND contype IN ('p','u',' x')) WHERE c.oid = '16389' AND c.oid = i.indrelid AND i.indexrelid = c2.oid ORDER BY i.indisprimary DESC, i.indisunique DESC, c2.relname;"
	psql -Xc "SELECT c2.relname, i.indexrelid, pg_catalog.pg_get_indexdef(i.indexrelid, 0, true)
	FROM pg_catalog.pg_class c, pg_catalog.pg_class c2,
	pg_catalog.pg_index i WHERE c.relname = 't' AND c.oid = i.indrelid AND i.indexrelid = c2.oid;"
	sleep 1
done