Highlights of PGconf.EU

Wed 2 Nov Michiel Toneman from Adyen kicked things off with a keynote mentioning how Adyen have been using PostgreSQL for the past 9 years. I wasn’t aware Michiel was...
November 04, 2016

Postgres-XL Scalability for Loading Data

In my last blog , we looked at the benchmark results from bulk load test for a Postgres-XL database cluster. Using a 16-datanode, 2-coordinator cluster, running on EC2 instances, we...
October 24, 2016

pglogical 1.2 with PostgreSQL 9.6 support

PostgreSQL 9.6 is now out and so is an updated version of pglogical that works with it. For quick guide on how to upgrade the database with pglogical you can...
October 20, 2016

PostgreSQL and the Platinum Guarantee

2ndQuadrant experts have recently fixed a bug in PostgreSQL, outstanding since the 9.3 release, that causes Free Space Map (FSM) corruption, resulting in INSERT/UPDATE queries to fail on the affected...
October 19, 2016

BDR History and future

BDR is both a patch to PostgreSQL core and an extension on top of PostgreSQL core. How did that come about, and what’s it’s future? Development of BDR was initiated...
October 18, 2016

Load data in Postgres-XL at over 9M rows/sec

We are faced with this question: “What’s the ingestion rate of Postgres-XL ?”, and I realised I don’t have a very good answer to that. Since recently we made some...
October 13, 2016

More ‘POWER’ for PostgreSQL

Now Available! Debian and Ubuntu packages for Power Architecture. The official announcement was published last Friday, September 30, 2016: the PostgreSQL repository for Debian and Ubuntu packages, apt.postgresql.org, has been...
October 07, 2016