Mastodon

See all posts by Cédric Villemain

Blog RSS feed
The text 'Cumulative Statistics in PostgreSQL 18 - A blog focused on the updates introduced to the statistics &.monitoring subsystem in PostgreSQL 18. Here, we’ll explore what’s new, what to watch out for, GUC knobs, and how extension authors can leverage the new C API surface.' with the PostgreSQL elephant logo above and the Data Bene logo underneath.
Free Software, PostgreSQL, Programming, Statistics

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.

by Cédric Villemain
The text 'Return of HOW2025 - An event focused on open source and PostgreSQL in Jinan, China' with logos for Data Bene, PostgreSQL, and IvorySQL displayed.
Community, Conference, Free Software, Open Source, PostgreSQL

Return of HOW2025

The Highgo Open World conference, dedicated to the PostgreSQL ecosystem and the IvorySQL project, was held on June 27 and 28. Read on for a recap of the experience and an introduction of our partnership with Highgo.

by Cédric Villemain
 PostgreSQL elephant in secure vault streaming QR codes
Backup, PostgreSQL, Programming, QRCode, Restore, Story

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.