did u ever read so hard u accidentally wrote?

A production Postgres database owner investigates periodic spikes in WALWrite processes and discovers the role of read-only queries in dirtying pages through hint bits. The spikes are traced back to a Datastream backfill and an ongoing transaction that periodically causes write contention despite the read-only nature of the workload.