Back to browse
GitHub Repository

A PostgreSQL extension that can enforce optimal column alignment to minimize row padding waste.

98 starsPLpgSQL

Pg_column_Tetris – a pg extension for optimal column alignment

by rogerw·Apr 30, 2026·2 points·0 comments

AI Analysis

●●SolidBig BrainSolve My Problem

Blocks suboptimal CREATE TABLE inside Postgres when SQLFluff only lints.

Strengths
  • Blocks suboptimal DDL directly in the database engine via extension hooks.
  • Visualizes byte-level padding waste clearly for developers unfamiliar with alignment.
  • Generates migration scripts to fix existing tables without manual reordering work.
Weaknesses
  • Requires superuser privileges to install extension on managed Postgres services.
  • Only solves storage padding, not index fragmentation or query planning issues.
Target Audience

PostgreSQL DBAs, Backend engineers managing large-scale databases

Similar To

SQLFluff · pglint · EXPLAIN

Similar Projects