#PostgreSQL articles

A PostgreSQL restore can recover every row and still leave the application unable to insert the next one. To understand why, we need to look at ownership, table...

Let’s say you’re processing events from an API into your CRM. An event comes in and tells you that a particular contact is a Director at a company. So you updat...

I’m a long term user of MySQL with both asynchronous replication and synchronous with PXC. For a while now this has been on Kubernetes with either Helm deployme...

Two successful reservations of three units should reduce stock from ten to four. A read-calculate-write operation can instead leave seven: both clients overwrit...

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 ...