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 TABLE
test=# INSERT INTO t_demo
SELECT id, hashtext(id::text)
FROM generate_series(1, 5000000000) AS id;
INSERT 0 5000000000
Laisser un commentaire