Richard Yen: I Fought the WAL, and the WAL Won: Why hot_standby_feedback can be Misleading Planet PostgreSQL

Introduction When I first got involved in managing a Postgres database, I was quickly introduced to the need for replication. My first project was to get our databases up on Slony, which was the hot new replication technology, replacing our clunky DRBD setup and allowing near-realtime read-only copies of the database. Of course, with time and scale, Slony had a hard time keeping up with the write traffic, especially since it ultimately suffered from write…

External feed Read More at the Source: https://postgr.es/p/4mZ