BitPage

Databases

PostgreSQL, ClickHouse, MySQL. Migrations, optimization under load, incident post-mortems, escaping rules, common traps in mixed stacks.

1 article

PostgreSQL conflict with recovery: why both standard fixes make it worse under Patroni

With replication slots enabled, hot_standby_feedback moves the bloat risk onto the primary; raising max_standby_streaming_delay feeds the HAProxy check that ejects the replica. Two hundred cancelled queries and thirty-odd replica ejections looked like one problem, but barely one in twenty lined up.