Time: 
2016-04-24 15:00 to 2016-04-24 16:00
Room: 
HC-103

Experience level

Learner

Session Track

Postgres

PGLOGICAL, Next Generation Replication for PostgreSQL

pglogical offers Logical Replication as a PostgreSQL extension, which provides the flexibility of trigger-based replication with the efficiency of log-based replication. This ground-breaking new technology has benefits for many key use cases, including:

- UPGRADE Upgrade PostgreSQL from 9.4 to 9.5, without downtime
- SCALE OUT Copy all or a selection of database tables to other nodes in a cluster
- AGGREGATE Accumulate changes from sharded database servers into a Data Warehouse
- INTEGRATE Feed database changes in real-time to other systems
- PROTECT Provide backup or high availability for clusters, replacing earlier technologies

Existing PostgreSQL users will find the efficiency of pglogical particularly exciting with preliminary testing demonstrating a significant increase in transaction throughput (without lag) over other replication methods. For example, pglogical performed up to 5 times faster than Slony and Londiste3 on OLTP workloads using pgbench