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...
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...
The recently released repmgr 3.1.4 update incorporates several changes which improve usability and lay out the groundwork for enhanced compatibility with 2ndQuadrant’s barman product. New configuration option restore_command It’s now...
PostgreSQL is an awesome project and it evolves at an amazing rate. We’ll focus on evolution of fault tolerance capabilities in PostgreSQL throughout its versions with a series of blog...
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...
Just got back from extended trip to Database.Camp – Sunday, July 10, 2016 – at the UN in NYC – Totally Free! Wide range of presentations from CTOs/CEOs from across...
Last week, 2ndQuadrant‘s Gabriele Bartolini was privileged to speak at IBM Italia’s Open Innovation event in Milan, Italy. At this event, IBM highlighted the strengths of open source such as...
PostgreSQL’s manual is generally pretty clear about the locks taken by various operations – but nothing’s perfect. If you need to, you can also ask PostgreSQL directly. You can check...
I had the pleasure to attend PGDay UK last week – a very nice event, hopefully I’ll have the chance to come back next year. There was plenty of interesting...
For a long time, one of the most known shortcomings of PostgreSQL was the ability to parallelise queries. With the release of version 9.6, this will no longer be an...
