Reducing table size with optimal column ordering and array-based storage
Find the article on our blog here:
https://pganalyze.com/blog/5mins-post...
In E100 of "5mins of Postgres" we discuss how to optimize the row size in Postgres to reduce the overall table size. Specifically, we take a look at how column ordering affects storage size, how you can play column tetris to optimize it, and the big benefits that array-based storage can yield for some workloads.
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
https://pganalyze.com/resources
📑 What we have discussed in this episode of 5mins of Postgres:
On Rocks and Sand
https://www.2ndquadrant.com/en/blog/o...
Calculating and saving space in PostgreSQL
https://stackoverflow.com/questions/2...
Does the optimized column order for a PostgreSQL table always have variable length types at the end?
https://dba.stackexchange.com/questio...
pg_column_byte_packer - PostgreSQL Column Byte Packer
https://github.com/braintree/pg_colum...
PostgreSQL Deep Dive: How Your Data Model Affects Storage
https://www.crunchydata.com/blog/how-...
pganalyze
https://pganalyze.com/