postgres cluster table
ghdrako edited this page Mar 8, 2024
·
1 revision
The CLUSTER clause will rewrite the table in the same order as a btree index. If you are running an analytical workload, this can make sense.
Consider checking out pg_squeeze as well, which is an extension to reorganize a table without extensive table locking.
Test