#PostgreSQL articles and events

Percona is a Bronze sponsor at AWS re:Invent, November 30-December 4 in Las Vegas. We’ll be on the Expo floor with the cloud community — talking open source dat...

Percona is a Silver sponsor at KubeCon + CloudNativeCon North America, November 9-12 in Salt Lake City, Utah. Find us in the Solutions Showcase to talk database...

Percona is a Gold sponsor at PGConf Europe, October 20-23 in Valencia. We contribute to the PostgreSQL community year-round — this is where we catch up with con...

Prague PostgreSQL Meetup takes place 2026-09-30....

Toulouse PostgreSQL User Group takes place 2026-09-22 in Toulouse....

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

We often hear that open source is about people....