Hacker News new | ask | show | jobs
by ako 1860 days ago
You can also use the index to cluster database blocks of the table based on the index (postgres => cluster command). This means all active records will be written to the same database blocks, and all deleted records will be kept in separate database blocks. This can speed up queries that need to access a lot of active records.

This is a good alternative to moving deleted records from an active table to a deleted table.