EPISODE · Jun 10, 2026 · 9 MIN
Why Database Column Compression Saves Millions
from Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations · host Fexingo
Episode 43 of Database Tech with Fexingo digs into column-level compression — a technique that reduced one company's storage bill by 70 percent and sped up analytic queries by 40 percent. Lucas and Luna break down how compression works under the hood, why it's not a one-size-fits-all solution, and which database systems support it natively. They also discuss trade-offs: decompression overhead for write-heavy workloads, and how to choose the right algorithm (dictionary, run-length, or delta encoding) for your data. If you've ever wondered why your cloud database bill keeps climbing despite aggressive indexing, this episode offers a concrete, actionable fix. Plus: a quick note on listener support that keeps this show ad-free. #ColumnCompression #DatabaseStorage #SQL #NoSQL #DataEngineering #PostgreSQL #MySQL #Snowflake #Redshift #CloudCosts #CompressionAlgorithms #DictionaryEncoding #RunLengthEncoding #DeltaEncoding #QueryPerformance #Technology #FexingoBusiness #BusinessPodcast Keep every episode free: buymeacoffee.com/fexingo
What this episode covers
Episode 43 of Database Tech with Fexingo digs into column-level compression — a technique that reduced one company's storage bill by 70 percent and sped up analytic queries by 40 percent. Lucas and Luna break down how compression works under the hood, why it's not a one-size-fits-all solution, and which database systems support it natively. They also discuss trade-offs: decompression overhead for write-heavy workloads, and how to choose the right algorithm (dictionary, run-length, or delta encoding) for your data. If you've ever wondered why your cloud database bill keeps climbing despite aggressive indexing, this episode offers a concrete, actionable fix. Plus: a quick note on listener support that keeps this show ad-free. #ColumnCompression #DatabaseStorage #SQL #NoSQL #DataEngineering #PostgreSQL #MySQL #Snowflake #Redshift #CloudCosts #CompressionAlgorithms #DictionaryEncoding #RunLengthEncoding #DeltaEncoding #QueryPerformance #Technology #FexingoBusiness #BusinessPodcast Keep every episode free: buymeacoffee.com/fexingo
NOW PLAYING
Why Database Column Compression Saves Millions
No transcript for this episode yet
Similar Episodes
Mar 26, 2026 ·1m
Mar 19, 2026 ·34m
Feb 18, 2026 ·11m
Feb 11, 2026 ·45m