Logical replication internals
This post explains how logical replication works. Especially, difference behaviors depending of workloads
Adrien Nayrat
PostgreSQL DBA Freelance
For seven years, I held various positions as a systems and network engineer. And it was in 2013 that I first started working with PostgreSQL. I held positions as a consultant, trainer, and also production DBA (Doctolib, Peopledoc).
This blog is a place where I share my findings, knowledge and talks.
Postgres and Netdata : apply to autovacuum and pg_stat_bgwriter
Introduction of autovacuum and bgwriter charts dedicated to PostgreSQL in Netdata
PostgreSQL 10 : ICU & Abbreviated Keys
Almost everyone has heard of partitioning and logical replication in PostgreSQL 10. Have you heard about the support of ICU collations (International Components for Unicode)? This …
PostgreSQL 10 : Performances improvements
PostgreSQL 10 is coming soon, it is scheduled for tomorrow : See this commit This release includes expected features : Logical replication Native partitioning Better parallelism …
PGDay : How does Full Text Search works?
During last PGDay I gave a presentation how Full Text Search works in PostgreSQL. This feature is unfortunately not well known. I see several reasons for this: Complexity: The FTS …
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 : …
PostgreSQL : Deferrable constraints
Differ constraints verification Note: This article was written during my activity at Dalibo Postgres respects ACID properties, so it guarantees the consistency of the database: a …
BRIN Indexes – Performances
PostgreSQL 9.5 released in january 2016 brings a new kind of index: BRIN indexes for Bloc Range INdex. They are recommanded when tables are very big and correlated with their …
BRIN Indexes – Correlation
PostgreSQL 9.5 released in january 2016 brings a new kind of index: BRIN indexes for Bloc Range INdex. They are recommanded when tables are very big and correlated with their …