Étiquette : Partitioning
-
Create a big test table
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 […]
-
[Postgres] Use of partitionning
Improving PostgreSQL Performance with Partitioning My recommended methodology for performance improvement of PostgreSQL starts with query optimization. The second step is architectural improvements, part of which is the partitioning of […]
