./tmp_install/home/matthias/pg-installs/pg-dyn-prefix-truncation/bin/pgbench --transactions=10 --report-per-command --no-vacuum --client=1 --log --file=/mnt/c/Users/Matthias/AppData/Roaming/JetBrains/CLion2022 .1/scratches/scratch_32.sql postgres --port 5435 pgbench (15beta1) transaction type: /mnt/c/Users/Matthias/AppData/Roaming/JetBrains/CLion2022.1/scratches/scratch_32.sql scaling factor: 1 query mode: simple number of clients: 1 number of threads: 1 maximum number of tries: 1 number of transactions per client: 10 number of transactions actually processed: 10/10 number of failed transactions: 0 (0.000%) latency average = 1202376.545 ms initial connection time = 0.979 ms tps = 0.000832 (without initial connection time) statement latencies in milliseconds and failures: 0.084 0 BEGIN; 67.634 0 CREATE UNIQUE INDEX uidx ON index_test USING btree (transaction); 62333.041 0 INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk /* uidx */; 8174.137 0 REINDEX INDEX uidx; 0.169 0 DROP INDEX uidx; 6.009 0 TRUNCATE index_test; 1.587 0 CREATE INDEX ccl ON index_test USING btree (county, city, locality); 52860.894 0 INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk /* ccl */; 30123.028 0 REINDEX INDEX ccl; 0.175 0 DROP INDEX ccl; 291.493 0 TRUNCATE index_test; 15.538 0 CREATE INDEX ccl_collated ON index_test USING btree (county COLLATE "en_US", city, locality); 69129.257 0 INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk /* ccl_collated */; 34831.026 0 REINDEX INDEX ccl_collated; 0.159 0 DROP INDEX ccl_collated; 314.660 0 TRUNCATE index_test; 20.897 0 CREATE INDEX accl ON index_test USING btree (always_null, county, city, locality); 56197.957 0 INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk /* accl */; 34153.793 0 REINDEX INDEX accl; 0.156 0 DROP INDEX accl; 322.171 0 TRUNCATE index_test; 20.964 0 CREATE INDEX tnt ON index_test USING btree (transfer_date, newly_built, transaction); 44602.319 0 INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk /* tnt */; 15685.726 0 REINDEX INDEX tnt; 0.152 0 DROP INDEX tnt; 338.070 0 TRUNCATE index_test; 19.771 0 CREATE INDEX worstcase 476300.988 0 INSERT INTO index_test SELECT * FROM land_registry_price_paid_uk /* worstcase */; 315170.180 0 REINDEX INDEX worstcase; 0.206 0 DROP INDEX worstcase; 360.998 0 TRUNCATE index_test; 1033.285 0 COMMIT;