PostgreSQL vs. Linux kernel versions

I’ve published multiple benchmarks comparing different PostgreSQL versions, as for example the performance archaeology talk (evaluating PostgreSQL 7.4 up to 9.4), and all those benchmark assumed fixed environment (hardware, kernel...
August 08, 2016

Thoughts on Uber’s List of Postgres Limitations

An Uber technical blog of July 2016 described the perception of “many Postgres limitations”. Regrettably, a number of important technical points are either not correct or not wholly correct because...
August 02, 2016

PostgreSQL 10 Roadmap

At the PostgreSQL developer meeting we discussed putting up everybody’s roadmap projects in one place: http://wiki.postgresql.org/wiki/PostgreSQL10_Roadmap. 2ndQuadrant PostgreSQL Roadmap Projects Logical Replication Use Case: Upgrade Use Case: Partial database replication...
August 02, 2016

Speed up getting WAL files from Barman

Starting from Barman 1.6.1, PostgreSQL standby servers can rely on an “infinite” basin of WAL files and finally pre-fetch batches of WAL files in parallel from Barman, speeding up the...
July 19, 2016

Evolution of Fault Tolerance in PostgreSQL

“It is paradoxical, yet true, to say, that the more we know, the more ignorant we become in the absolute sense, for it is only through enlightenment that we become...
July 04, 2016