Logical replication

Logical replication internals

This post explains how logical replication works. Especially, difference beharvoirs depending of workloads

PostgreSQL 10 and Logical replication - Setup

This article is the result of a series of articles on logical replication in PostgreSQL 10 This one will focus on the implementation of logical replication.

PostgreSQL 10 and Logical replication - Overview

Next PostgreSQL version is approaching. This version comes with an impressive feature list : Native partionning Sorts and aggregation improvements Better parallelism support : parallel index scan, parallel hash join, parallelism for subquery Extended statistics ICU collation: enable use of “abbreviated keys”, disabled in 9.5.2 due to libc bug. Abbreviated keys brings sort improvements (arround 20-30%). It is usefull when a query need a sort or for index creation. … look at wiki page New in Postgres 10 or releases notes. Another attended feature is logical replication. I will present it in a serie of articles.