bench.sql

application/x-sql

Filename: bench.sql

Type: application/x-sql

Part: 1

Message: postgres_fdw: Use COPY to speed up batch inserts

-- Table setup
-- CREATE TABLE t (
--     id integer not null,
--     value INTEGER NOT NULL,
--     note TEXT
-- );

INSERT INTO t (id, value, note)
SELECT generate_series(1, 10000),
       random() * 100000,
       'batch insert test data' || generate_series(1, 10000);