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 […]
PostgreSQL Solution Architecture
/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsKeynote 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
/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsWed 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. http://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
/0 Comments/in 2ndQuadrant, Featured, Howard Postgres Marketing World, Howard's PlanetPostgreSQL, United States News /by Umair ShahidThe 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
/2 Comments/in Pavan's PlanetPostgreSQL /by Pavan DeolaseeIn 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
/0 Comments/in Petr's PlanetPostgreSQL /by Petr JelinekPostgreSQL 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 […]
PostgreSQL and the Platinum Guarantee
/0 Comments/in Britt's Marketing /by Britt Cole2ndQuadrant 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 table. More details here. The fix will be included in maintenance releases for PostgreSQL due in next quarter, but has already been released to 2ndQuadrant customers. This […]
BDR History and future
/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringerBDR 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 around the time PostgreSQL 9.2 was in development. Arguably earlier if you count things like the extension mechanism. The goal of BDR is, and has […]
Back to the Future Part 3: pg_rewind with PostgreSQL 9.6
/0 Comments/in 2ndQuadrant, Giuseppe's PlanetPostgreSQL /by 2ndQuadrant PressThis is the third and last part of blog articles dedicated to pg_rewind. In the two previous articles we have seen how pg_rewind is useful to fix split-brain events due to mistakes in the switchover procedures, avoiding the need of new base backups. We have also seen that this is true for simple replication clusters, where more standby nodes are involved.
Load data in Postgres-XL at over 9M rows/sec
/6 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL /by Pavan DeolaseeWe 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 good improvements in this area, I was curious to know too. Well, I decided to benchmark. Hardware and Software For the tests, I used a Postgres-XL cluster running […]
repmgr 3.2 is here with Barman support and Brand New High Availability features
/0 Comments/in Ian's PlanetPostgreSQL, repmgr /by Ian Barwickrepmgr 3.2 has recently been released with a number of enhancements, particularly support for 2ndQuadrant’s Barman archive management server, additional cluster monitoring functionality and improvements to the standby cloning process. One aim of this release is to remove the requirement to set up passwordless SSH between servers, which means when using repmgr’s standard functionality to […]