One of the problems with Postgres-XL 9.2 is that it assigns a global transaction identifier (GXID) for every transaction that is started in the cluster. Since its hard for the...
It is always exciting to meet community members and exchange ideas about PostgreSQL and the eco-system around the database. I was lucky enough to be a part of FOSDEM PGDay...
The 9th annual “ Prague PostgreSQL Developer Day” conference will be held on 17th and 18th February in Prague. Me with PostgreSQL elephants at Prague Zoo 🙂 Welcome to Prague...
PgBouncer is a lightweight connection pooler for PostgreSQL. PgBouncer 1.7 was announced on the 18th of December 2015. In this blog post we’ll talk about the major new improvements in...
Ansible Galaxy is simply the easiest way of finding already written Ansible roles, creating and sharing your roles and jump into the galaxy of Ansible content! ==================== Prime time announcement...
I had the pleasure of speaking about PostgreSQL performance at The 14th Annual Southern California Linux Expo and meeting many enthusiastic database users in the expo hall. There was a...
PostgreSQL has typically been described as an OLTP-friendly database and has generally been put to the side for OLAP workloads. While I disagree with this notion to begin with, the...
In the previous blog post, I briefly explained how we got the performance numbers published in the pglogical announcement. In this blog post I’d like to discuss the performance limits...
During the last October’s Italian PGDay and European PostgreSQL conference, my friend Marco Nenciarini and I had the pleasure to talk about a new open source plugin for PostgreSQL, called...
pglogical (logical replication for PostgreSQL) is the latest in the series of awesome products developed & supported by 2ndQuadrant. One of the key ingredients to making any product great is...