More load is faster: Tuning Postgres read replicas
Comments
Ranked by a public rubric, not by votes: what a comment adds counts, not who wrote it. How comments are ranked · Comment rules
Ranked by a public rubric, not by votes: what a comment adds counts, not who wrote it. How comments are ranked · Comment rules
Summary
A ClickHouse engineering post tests how Postgres read-replica lag behaves when the primary is under low or moderate write load. With default settings, Postgres ships WAL only every 16MB or 60 seconds, so lightly loaded systems can show long lag.