Tag: Programming
Did you know? Tables in PostgreSQL are limited to 1,600 columns
It's a hard-coded limit in Postgres for tables to not exceed 1,600 columns. Let's test all the ways you can reach that limit, and explore how to address the situation when you reach this limit unexpectedly.
Cumulative Statistics in PostgreSQL 18
In PostgreSQL 18, the statistics & monitoring subsystem receives a significant overhaul - extended cumulative statistics, new per-backend I/O visibility, the ability for extensions to export / import / adjust statistics, and much more. Let's explore these changes.
Once Upon a Time in a Confined Database - PostgreSQL, QRCodes, and the Art of Backup Without a Network
In a room sealed tighter than a submarine vault, a PostgreSQL instance lived without network, external storage, or escape. No USB. No cloud. Just a screen—and a desperate need to back up critical data. Our solution? Modify pg_dump to stream QR codes at 60 frames per second, film the screen, and reassemble the dump from video. It wasn’t just secure—it was cinematic.
Postgres Café: Expand monitoring capabilities with StatsMgr
Introducing StatsMgr, a PostgreSQL extension designed for efficient and organized management of statistics. Learn more in our new Postgres Café blog and video series.
Strange data type transformations
An in depth look at strange data type transformations, when your function argument types might be changed differently than you expect.