|
|
|
|
|
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. |
|