Thursday, 3 October 2024

Failover Slots in PostgreSQL-17: Ensuring High Availability with Logical Replication

›
With the introduction of failover slots in PostgreSQL-17, logical replication can now be effectively utilized in high-availability environme...
Wednesday, 25 September 2024

Online Upgrading Logical and Physical Replication Nodes

›
In my last blog post, Evolution of Logical Replication , I mentioned the future development of a feature to allow "upgrades of logical ...
Monday, 25 September 2023

Evolution of Logical Replication

›
This blog post is about how the Logical Replication has evolved over the years in PostgreSQL, what's in the latest release-16 , and what...
Monday, 7 November 2022

Logical Replication Improvements in PostgreSQL-15

›
There are various areas in PostgreSQL like Partitioning, Logical Replication, Parallel Query, Vacuum, etc. which improve with each new versi...
Wednesday, 15 September 2021

Logical Replication Improvements In PostgreSQL-14

›
In the upcoming release of PostgreSQL-14, we will see multiple enhancements in Logical Replication which I hope will further increase its u...
5 comments:
Saturday, 17 July 2021

Logical Replication Of In-Progress Transactions

›
Logical Replication was introduced in PostgreSQL-10 and since then it is being improved with each version. Logical Replication is a method t...
Sunday, 10 May 2020

Improved (auto)vacuum in PostgreSQL 13

›
Vacuum is one of the sub-systems in PostgreSQL which gets improved with each release.  I have checked past five releases and each has qu...