r/PostgreSQL • • 10h ago

How-To More load is faster: tuning Postgres read replicas

Thumbnail clickhouse.com
7 Upvotes

Replica lag is lower than conventional wisdom suggests out of the box if you have traffic, and pretty easy to get to a few seconds with basic tuning.

You can get some spectacularly short replica lag if you’re willing to be unreasonable or incur tradeoffs.