Tagged articles
logical replication
11 articles · Page 1 of 1
PostgreSQL 18 introduces major improvements including asynchronous I/O for up to 3x scan performance, pg_upgrade preserving statistics and --swap for minute-level upgrades, virtual generated columns, UUIDv7, temporal constraints, enhanced observability, OAuth 2.0 authentication, and parallel logical replication, reducing operational overhead and boosting developer productivity.
PostgreSQL 18UUIDv7asynchronous I/O
0 likes · 12 min read

PostgreSQL 17, released on September 26 2024, brings major performance upgrades, enhanced memory management, faster vacuum, improved I/O, new SQL/JSON features, expanded logical replication, stronger security options, and a host of additional tools that modernize database development and administration.
PostgreSQLSQL/JSONdatabase
0 likes · 5 min read


ITPUBSep 28, 2024 · Databases
PostgreSQL 17, announced on 2024‑09‑26, brings major performance upgrades, extensive SQL/JSON enhancements, improved logical replication, new security and management options, and a host of developer‑friendly features that position it as the world’s most advanced open‑source database.
PostgreSQLSQL/JSONdatabase
0 likes · 14 min read


21CTOSep 18, 2023 · Databases
PostgreSQL 16, released in September 2023, brings major enhancements in permission management, logical replication, performance, and monitoring, offering finer‑grained security, faster data handling, and comprehensive observability for modern database workloads.
PostgreSQLdatabaselogical replication
0 likes · 6 min read

PostgreSQL 16 introduces enhanced parallel query capabilities, incremental sorting, SIMD acceleration, improved logical replication, and new monitoring tools like pg_stat_io, offering notable performance gains while still leaving some long‑awaited features such as XID‑64 absent.
Parallel QueryPostgreSQLSIMD
0 likes · 9 min read

This article explains PostgreSQL logical replication concepts, key components like replication slots and output plugins, common challenges such as failover slots, DDL sync, and bidirectional loops, and demonstrates practical full‑and‑incremental data migration to the cloud.
Cloud MigrationDDL SyncPostgreSQL
0 likes · 9 min read

This article shares practical experiences and lessons learned from over a hundred database migration projects, comparing storage replication, logical replication, and ASM disk‑group rebalancing, and explains how system context, vendor capabilities, and careful planning determine the most suitable approach.
ASMBest PracticesDatabase Migration
0 likes · 10 min read

This article describes how Coffee Meets Bagel upgraded a five‑node PostgreSQL 9.6 cluster to version 12.4 on AWS using pglogical logical replication, achieving less than 30 minutes of total downtime while sharing the architecture, migration steps, and lessons learned.
AWSDatabase MigrationHigh Availability
0 likes · 8 min read

The 10th PostgreSQL China Technical Conference in January 2021 featured expert talks on scaling Citus clusters with logical replication and on applying PostgreSQL to Suning’s retail digitalization, highlighting architecture, challenges, technology choices, and future directions for database-driven business transformation.
CitusPostgreSQLdata architecture
0 likes · 2 min read


ITPUBJan 5, 2018 · Databases
This article outlines the most compelling reasons to choose PostgreSQL, covering its advanced data types like JSONB and Range, powerful extensions such as Citus, HyperLogLog and PostGIS, logical replication, rich indexing options, upsert support, foreign data wrappers, and a host of legacy capabilities.
JSONBPostgreSQLdatabase
0 likes · 10 min read


ITPUBOct 9, 2017 · Databases
PostgreSQL 10, released after months of beta testing, brings logical replication, declarative table partitioning, higher query concurrency, notable performance gains, stronger SCRAM‑SHA‑256 authentication, and enhanced monitoring and control capabilities, marking a significant evolution for the open‑source database.
PostgreSQLTable Partitioningdatabase
0 likes · 3 min read
