Read

Feed
Explore
Latest

Library

Sources
Saved

Account

Profile
Settings

⌘ K

Loading

Loading articles

Feed
Explore
Latest
Sources
Saved

AWS Database Blog — BlogDrop

Sources/AWS Database Blog

AWS Database Blog

2 articles collected from this blog.

01
AWS Database Blog3d ago12 readmid
Resolving PostgreSQL replication lag with heartbeat tables in change data capture scenarios
This article explains how to mitigate PostgreSQL replication slot stalls and WAL accumulation during CDC-based migrations. By implementing heartbeat tables that periodically update a row, developers can force the replication slot LSN to advance, preventing disk space exhaustion when replicating only a subset of database tables.
AI summary
02
AWS Database Blog5d ago20 readsenior
Resolving query plan regressions after a MySQL engine upgrade
This article outlines the technical causes behind query performance regressions following MySQL major version upgrades, such as optimizer cost model changes and new default flags. It provides a systematic diagnostic workflow using tools like EXPLAIN ANALYZE and ANALYZE TABLE to isolate and resolve execution plan shifts. The guide emphasizes the importance of baseline performance snapshots and proper buffer pool management to ensure post-upgrade stability.
AI summary