PostgreSQL Extension for Row Padding, pgBackRest EOL, and SQLite Windows XP Support Today's Highlights This week features a new PostgreSQL extension for optimizing column alignment, critical news on the end-of-life for pgBackRest, and a forum discussion on SQLite's potential dropping of Windows XP support. Pg_column_tetris: A PostgreSQL extension that can enforce optimal column alignment to minimize row padding waste. (r/PostgreSQL) Source: https://reddit.com/r/PostgreSQL/comments/1sxi6fx/pg_column_tetris_a_postgresql_extension_that_can/ This news highlights a newly introduced PostgreSQL extension called pg_column_tetris . Its primary function is to help database administrators and developers optimize table storage by enforcing optimal column alignment. In relational databases like PostgreSQL, data types of varying sizes can lead to "padding" within a row, where the system adds empty bytes to align subsequent columns on memory boundaries for efficient access.…