CHAR (16) – Another conference on the horizon but with a focus on business

The PostgreSQL user community is becoming spoilt with a choice of excellent events organized by both local user groups and commercial organizations supporting the Postgre ...

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

Committed to the PostgreSQL Community, 2ndQuadrant Contributes to 9.6

The latest version of PostgreSQL 9.6 is planned to be released later today, bringing with it some much anticipated features and updates. As the most advanced open source ...

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

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

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. Version 2.0 takes Barman to a new level, thanks to full ...

Back to the Future Pt. 1: Introduction to pg_rewind

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

Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit

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

PostgreSQL vs. Linux kernel versions

I’ve published multiple benchmarks comparing different PostgreSQL versions, as for example the performance archaeology talk (evaluating PostgreSQL 7.4 up to 9.4), a ...

Evolution of Fault Tolerance in PostgreSQL: Time Travel

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

Speed up getting WAL files from Barman

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

CHAR(16) Scalability for Business

CHAR(16) Conference on Scalability for Business went very well in the heart of New York City. Hotel Pennsylvania was a great venue; convenient for travel and a great conference venue with coffee, food and evening drinks. Jonathan Katz was great as MC for the conference, while Eric David Benari did a great job of hosting…

Avoiding Disasters in New York

What to do when disaster strikes… (various topics) King Kong attacks! Lure up tall building and attack with biplanes Godzilla’s eggs hatch Team up with European Special Forces operative to escape, then call in airstrike on Madison Square Gardens Watch the Rangers lose at home (same as above) Global Warming descends quickly Stay holed up…

On the impact of full-page writes

While tweaking postgresql.conf, you might have noticed there’s an option called full_page_writes. The comment next to it says something about partial page writes, and people generally leave it set to on – which is a good thing, as I’ll explain later in this post. It’s however useful to understand what full page writes do, because…

PostgreSQL Meetup in Melbourne, Australia

If you live in the Melbourne area and you are passionate about PostgreSQL then don’t miss the chance to come to the Melbourne PostgreSQL Users Group Meetup this Monday, 21 November.

Basics of Tuning Checkpoints

On systems doing non-trivial number of writes, tuning checkpoints is crucial for getting good performance. Yet checkpoints are one of the areas where we often identify confusion and configuration issues, both on the community mailing lists and during performance tuning reviews for our customers. (The other one being autovacuum, discussed a few days ago by…

PostgreSQL Solution Architecture

Keynote at PgConf.EU was well attended. I have already written about my impressions of the conference here. PostgreSQL is becoming a complete solution architecture for data, based upon the capabilities to push and pull data to/from other datastores, including other types of datastore. A variety of components, large and small make up that full architecture,…

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 speaking, though I was very happy that he mentioned 2ndQuadrant’s extensive support of their multi-Terabyte PostgreSQL installations. https://www.postgresql.eu/events/schedule/pgconfeu2016/session/1419-building-a-unicorn-on-an-elephant/ I spent most of the first day…

CHAR (16) – Another conference on the horizon but with a focus on business

char16-blog-banner

The PostgreSQL user community is becoming spoilt with a choice of excellent events organized by both local user groups and commercial organizations supporting the PostgreSQL project.  And amongst the events taking place in December, the one you definitely shouldn’t miss attending is CHAR(16). ‘CHAR(16): Scalability for Business’ is intended to fulfill a different requirement – different…

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 could easily clock 9M rows/sec or 3TB/hr of ingestion rate. That’s a significant number in itself. In this blog, we’ll see if the ingestion rate is…

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 check my post which announced 9.6beta support. The main change besides the support for 9.6.x release of PostgreSQL is in the way we handle the…

12345Next ›Last »