Categories

Tag

logical replication

View Cards
Mode Paginated
Per page Per batch 72
Architecture

PostgreSQL 17: The Novelties That Show Promise

PostgreSQL 17, released in September 2024, cuts vacuum memory use by up to 20x, adds slot synchronization so logical replication survives a failover without a full resync, ships JSON_TABLE as standard SQL:2023 syntax, and introduces streaming I/O to speed up sequential scans. Teams running Postgres in production should start testing it in staging.

2 min 195
Architecture

PostgreSQL 16: Logical Replication That’s Now Practical

PostgreSQL 16 closes the historical gaps in logical replication: parallel apply near 2x faster, logical slots served from physical standbys, and the scaffolding for bidirectional replication. The result is a first-line tool for cross-version migrations and CDC pipelines.

3 min 194 4.4