Experience level
Session Track
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
Short Link: http://lfnw.org/node/3885