-- no results
\o /dev/null
\timing
\! date
\echo == Original Table ==
  vacuum analyze tycho (pos);
  create index pos_idx on tycho using gist(pos);
  vacuum analyze tycho (pos);
  \i queries.sql
\echo == Randomized table ==
  select * into table tycho_random from tycho order by random();
  alter table tycho rename to tycho_orig;
  alter table tycho_random rename to tycho;
  vacuum analyze tycho (pos);
  create index pos_random_idx on tycho using gist(pos);
  vacuum analyze tycho (pos);
  \i queries.sql
\echo == Clustering ==
  create index pos_z_idx on tycho(pos);
  vacuum analyze;
  cluster pos_z_idx on tycho;
  create index pos_clustered_idx on tycho using gist(pos);
  vacuum analyze tycho (pos);
  \i queries.sql
\echo == Done ==
\! date
