1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
| CREATE TABLE T1 ( ID INT NOT NULL PRIMARY KEY, val INT NOT NULL, col1 UUID NOT NULL, col2 UUID NOT NULL, col3 UUID NOT NULL, col4 UUID NOT NULL, col5 UUID NOT NULL, col6 UUID NOT NULL );
INSERT INTO T1 SELECT i, RANDOM() * 1000000, md5(random()::text || clock_timestamp()::text)::uuid, md5(random()::text || clock_timestamp()::text)::uuid, md5(random()::text || clock_timestamp()::text)::uuid, md5(random()::text || clock_timestamp()::text)::uuid, md5(random()::text || clock_timestamp()::text)::uuid, md5(random()::text || clock_timestamp()::text)::uuid FROM generate_series(1,20000000) i;
CREATE TABLE T2 ( ID INT NOT NULL PRIMARY KEY, val INT NOT NULL, col1 UUID NOT NULL, col2 UUID NOT NULL, col3 UUID NOT NULL, col4 UUID NOT NULL, col5 UUID NOT NULL, col6 UUID NOT NULL );
INSERT INTO T2 SELECT i, RANDOM() * 1000000, md5(random()::text || clock_timestamp()::text)::uuid, md5(random()::text || clock_timestamp()::text)::uuid, md5(random()::text || clock_timestamp()::text)::uuid, md5(random()::text || clock_timestamp()::text)::uuid, md5(random()::text || clock_timestamp()::text)::uuid, md5(random()::text || clock_timestamp()::text)::uuid FROM generate_series(1,1000000) i;
vacuum ANALYZE T1; vacuum ANALYZE T2;
|