#PostgreSQL articles

pg_stat_monitor started as a fork of pg_stat_statements, built to be a more advanced replacement for it. It provides more detailed information about query execu...

This is a synthetic laboratory example, not a customer production incident. AI assisted with drafting and checking the material....

Everyone who follows database news has already heard about the delays of PostgreSQL 19: the major release that was supposed to go GA in September, now scheduled...

I take over apps that were made with Lovable, Bolt or v0....

PGConf.EU is right around the corner! This year, we’re heading to Valencia for three days of talks on October 20-22, followed by the Community Events Day on Fri...

When you read about how LLMs help developers start on a project, it’s usually about how quickly they can create their first meaningful PRs. But is it really the...

Every document-processing system I have worked on arrives at the same shape. Something uploads a file, something else has to read it, run it through an extracti...

A backup is only useful if it can be restored. This lab seeds a source database, takes a logical archive, deliberately deletes the source database, restores int...

A database migration can be syntactically correct and still be a poor release candidate. A regular index build can block writes, an ALTER TABLE may wait behind ...

Back in February, I wrote about Hackorum, a forum style web view of the pg-hackers mailing list. If you missed that post, you can read it here first. It turns t...

I would like to introduce here the curious case that I had on a Patroni Cluster in production, after a migration from Oracle, with timezone differences between ...

What’s the impact of TDE on performance? People usually quickly throw together a few graphs with basic measurements and treat that as a complete answer, but the...

Recently we noticed a LinkedIn post promoting open_pg_tde, a fork of our pg_tde, claiming to be more open. I looked at the repository, and have to disagree with...

Vacuum, or more precisely autovacuum, is the most important automatic maintenance task in PostgreSQL. It is key for performance, but also for long-term database...

Here I write about what I changed after the first launch: hybrid search, filters and counts on the search page, the widget layout, indexer hardening, and the Pe...