do_clean_start.sql

Save this script as do_clean_start.sql.

-- Get a clean start.
-- These tables will store some query results so that, with
-- all these in a single table, it is easy to use
-- SQL to compare results from different tests.

set client_min_messages = warning;
drop table if exists dp_results cascade;
create table dp_results(
  method  text              not null,
  bucket  int               not null,
  n       int               not null,
  min_s   double precision  not null,
  max_s   double precision  not null,

  constraint dp_results_pk primary key(method, bucket));

drop table if exists int_results cascade;
create table int_results(
  method  text              not null,
  bucket  int               not null,
  n       int               not null,
  min_s   double precision  not null,
  max_s   double precision  not null,

  constraint int_results_pk primary key(method, bucket));