Hacking Postgres with Andrey, Kirk, Nik

session summary

The group connected archive-fed logical decoding to resilient analytical replication: replay should pause before catalog cleanup invalidates a lagging slot, then resume automatically once consumption catches up. They manually audited an AI-generated prototype and its complex TAP test, discovering that the test needed clearer assertions around the actual paused state. They accepted a proof-of-concept pause GUC, rejected manual resume as incomplete, and designed auto-resume behavior for drained, dropped, or otherwise nonblocking slots.

timecodes

1. 00:30 Archive-fed decoding for resilient analytics
2. 05:00 From meeting transcript to AI-built prototype
3. 07:00 Logical archive during large initial synchronization
4. 21:00 Pause replay instead of blocking primary vacuum
5. 28:00 Opening the prototype for manual review
6. 38:00 Understanding the pause-on-conflict TAP test
7. 47:30 Missing assertions for the paused recovery state
8. 01:04:30 Designing automatic recovery resume