postgres Archives - Page 3 of 9 - 2ndQuadrant

Posts

Back to the Future Pt. 2: How to use pg_rewind with PostgreSQL 9.5

September 28, 2016/0 Comments/in 2ndQuadrant, Featured, Giuseppe's PlanetPostgreSQL /by 2ndQuadrant Press

In the previous blog article we have seen how pg_rewind works with a simple HA cluster, composed of a master node replicating to a standby. In this context, an eventual switchover involves just two nodes that have to be aligned. But what happens with HA clusters when there are several (also cascading) standbys? Now, consider […]

The Best Barman Ever

September 27, 2016/0 Comments/in 2ndQuadrant, Featured, Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

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

September 12, 2016/16 Comments/in 2ndQuadrant, Featured, Giuseppe's PlanetPostgreSQL /by 2ndQuadrant Press

Since 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 […]

Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit

August 17, 2016/2 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin Yildirim

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

August 8, 2016/14 Comments/in 2ndQuadrant, Featured, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

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, …). Which is fine in many cases (e.g. when evaluating performance impact of a patch), but on production those things do change over time – […]

Thoughts on Uber’s List of Postgres Limitations

August 2, 2016/6 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

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

August 2, 2016/8 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

At the PostgreSQL developer meeting we discussed putting up everybody’s roadmap projects in one place: http://wiki.postgresql.org/wiki/PostgreSQL10_Roadmap.

Evolution of Fault Tolerance in PostgreSQL: Time Travel

July 21, 2016/0 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin Yildirim

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 posts. This is the third post of the series and we’ll talk about timeline issues and their effects on fault tolerance and dependability of PostgreSQL. […]

Speed up getting WAL files from Barman

July 19, 2016/0 Comments/in Featured, Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

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 restoration process as well as making the disaster recovery solution more resilient as a whole. The master, the backup and the standby Before we start, […]

Evolution of Fault Tolerance in PostgreSQL: Replication Phase

July 11, 2016/0 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin Yildirim

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 posts. This is the second post of the series and we’ll talk about replication and its importance on fault tolerance and dependability of PostgreSQL. If […]