source : /https://www.cybertec-postgresql.com/en/btree-vs-brin-2-options-for-indexing-in-postgresql-data-warehouses/ btree vs. BRIN: 2 options for indexing in PostgreSQL data warehouses Create a big random table : test=# CREATE TABLE t_demo (id_sorted int8, id_random int8);CREATE TABLEtest=# INSERT […]