Skip to content
Tagged articles

logical replication

11 articles · Page 1 of 1
Cilantro Loves Linux
Cilantro Loves Linux
Sep 26, 2025 · Databases

PostgreSQL 18 Released: 5 Key Innovations for Performance, Upgrades & Developer Productivity

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 18 Released: 5 Key Innovations for Performance, Upgrades & Developer Productivity
ITPUB
ITPUB
Sep 28, 2024 · Databases

What’s New in PostgreSQL 17? A Deep Dive into Performance and Feature Boosts

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
What’s New in PostgreSQL 17? A Deep Dive into Performance and Feature Boosts
dbaplus Community
dbaplus Community
Jun 8, 2022 · Databases

Choosing the Right Database Migration Strategy: Real-World Lessons and Pitfalls

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
Choosing the Right Database Migration Strategy: Real-World Lessons and Pitfalls
Suning Technology
Suning Technology
Jan 19, 2021 · Databases

Scaling Citus Clusters via Logical Replication – Lessons from PostgreSQL China Conference

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
Scaling Citus Clusters via Logical Replication – Lessons from PostgreSQL China Conference
ITPUB
ITPUB
Jan 5, 2018 · Databases

Why PostgreSQL Stands Out: Essential Features and Extensions Explained

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
Why PostgreSQL Stands Out: Essential Features and Extensions Explained
ITPUB
ITPUB
Oct 9, 2017 · Databases

What’s New in PostgreSQL 10? Key Features and Improvements Explained

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
What’s New in PostgreSQL 10? Key Features and Improvements Explained