Nov 082022
 

There are various areas in PostgreSQL like Partitioning, Logical Replication, Parallel Query, Vacuum, etc. which improve with each new version. In this blog, I’ll summarize the various enhancements in Logical Replication that users could see in the recently released PostgreSQL 15. You can read the enhancements in this area in the previous release in one of my previous blogs.Allow replication of prepared transactions:In the last release, we allowed logical decoding of prepared transactions and with this release, we added the support to replicate prepared transactions to built-in logical replication. Previously, we send the changes of the prepared transaction only once the commit prepared had been done. Users can enable replication at PREPARE time with the following syntax:CREATE PUBLICATION  mypub…

External feed Read More at the Source: https://postgr.es/p/5rN

 2022-11-08  Comments Off on Planet PostgreSQL – Amit Kapila: Logical Replication Improvements in PostgreSQL-15