4 ms·
Although it isn't automatic, doesn't the Postgres CLUSTER command reorder the rows on disk? Or am I misunderstanding something?
by mthoms 2y ago
Although it isn't automatic, doesn't the Postgres CLUSTER command reorder the rows on disk? Or am I misunderstanding something?
- tehlike 2y agoIt does, but it's a bit of a problem when table is large and gets new rows since by default it locks the table and is a slow operation. Oh and also does compression which helps quite a bit with network storages (like cloud disks)