Show HN: Pg_column_Tetris – a pg extension for optimal column alignment

Category: database

Tags: postgresql, optimization, column-alignment

Score: 6.8/10 (Innovation: 6, Technical: 6, Documentation: 8, Utility: 7)

Pg_column_Tetris is a PostgreSQL extension that helps optimize table column alignment to minimize row padding waste, improving storage efficiency and query performance with zero runtime cost. It offers several modes (warn, strict, analysis) to integrate into development and CI/CD workflows. The project is interesting because it addresses a common but often overlooked PostgreSQL optimization with a practical, non-invasive tool.

Target audience: backend devs, devops, database administrators

Repository: https://github.com/rogerwelin/pg_column_tetris · PLpgSQL · MIT · 15 stars

View on Hacker News