pg_uuid_benchmark.txt

-- 100 million INSERTs benchmark
-- stock PostgreSQL 9.6 setup running on an Ubuntu 16.04 workstation

-- PK TYPE    INSERT* time (ms)   Relative time    AVG throughput (op/s)
------------------------------------------------------------------------
-- BIGSERIAL         242,849.46            1.00               411,777.73
-- UUID COMB         337,028.15            1.39               296,711.12
-- UUID 1            470,385.37            1.94               212,591.65
-- UUID 4          7,808,502.45           32.15                12,806.55
------------------------------------------------------------------------

CREATE TABLE uuids (
  id UUID PRIMARY KEY
);

CREATE TABLE serials (
  id BIGSERIAL PRIMARY KEY
);

-- *not quite, done like this (and truncating the table inbetween tests):
COPY uuids FROM '/some/path/uuid1.csv';