Found 2 bookmarks
Custom sorting
Optimizing Postgres table layout for maximum efficiency
Optimizing Postgres table layout for maximum efficiency
Introduction When modeling a Postgres database, you probably don’t give much thought to the order of columns in your tables. After all, it seems like the kind of thing that wouldn’t affect storage or performance. But what if I told you that simply reordering your columns could reduce the size of your tables and indexes by 20%? This isn’t some obscure database trick — it’s a direct result of how Postgres aligns data on disk.\n
·r.ena.to·
Optimizing Postgres table layout for maximum efficiency