The Best Barman Ever
This is my (very) biased opinion, but I am ready to bet that once you try Barman 2.0 you’ll agree with me.
Back to the Future Pt. 1: Introduction to pg_rewind
/14 Comments/in 2ndQuadrant, Featured, Giuseppe's PlanetPostgreSQL /by 2ndQuadrant PressSince PostgreSQL 9.5, pg_rewind has been able to make a former master follow up a promoted standby although, in the meantime, it proceeded with its own timeline. Consider, for instance, the case of a switchover that didn’t work properly. Have you ever experienced a "split brain" during a switchover operation? You know, when the goal […]
PostgreSQL 9.1 End of Life
/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsAs you may have seen, PostgreSQL 9.1 has now reached its End of Life. That means the last maintenance update of 9.1 will be in November 2016. PostgreSQL 9.6 is currently due out in September 2016, so you have a chance to move from PostgreSQL 9.1 to PostgreSQL 9.6. Supported upgrade choices are pg_upgrade pg_dump […]
When to use Postgres-BDR or Postgres-XL?
/1 Comment/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsThe right answer is of course “Use PostgreSQL”. It’s the main distro and we want you to use that as often as possible. The Postgres-BDR and Postgres-XL projects are also fully open source projects, using the same copyright and licence as the main PostgreSQL project. So if you’re using PostgreSQL, they are also options to […]
Postgres-BDR: 2 Years in Production
/1 Comment/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsPostgres-BDR has now reached 1.0 production status. Over the last 2 years, Postgres-BDR has been used daily for mission critical production systems. As you might imagine, it’s been improved by both bug fixes and feature enhancements that allow it to be used smoothly, so its mature, robust and feature-rich. The BDR Project introduced logical replication […]
Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit
/3 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin YildirimPostgreSQL 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 posts. This is the fourth post of the series and we’ll talk about synchronous commit and its effects on fault tolerance and dependability of PostgreSQL. […]
PostgreSQL vs. Linux kernel versions
/14 Comments/in 2ndQuadrant, Featured, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas VondraI’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, …). Which is fine in many cases (e.g. when evaluating performance impact of a patch), but on production those things do change over time – […]
PostgreSQL Solutions Roadmap
/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsIn a recent blog, I described features for PostgreSQL Core that we’ve been working on https://www.2ndquadrant.com/en/blog/postgresql-solutions-roadmap/ Many people have asked for a similar roadmap for BDR and Postgres-XL. I can confirm that both are under active development and in active use. Postgres-XL (link) XL 9.5 v1.2 is now available, with more updates coming. XL 9.6 […]
Thoughts on Uber’s List of Postgres Limitations
/11 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsAn 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 they overlook many optimizations in PostgreSQL that were added specifically to address the cases discussed. In most cases, those limitations were actually true in the […]
PostgreSQL 10 Roadmap
/10 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsAt the PostgreSQL developer meeting we discussed putting up everybody’s roadmap projects in one place: http://wiki.postgresql.org/wiki/PostgreSQL10_Roadmap.
