Re: WAL Replay Buffer Invalidation Conflicts During Page Truncation on Read Replicas

Thanks Alvaro, I read the thread and actually disabled truncate on my table with a large toast table which mitigated the issue. Unsure what happens with the empty pages now, I guess they would be reused for new inserts. I would like to see if there are better opportunities to improve this truncati

WAL Replay Buffer Invalidation Conflicts During Page Truncation on Read Replicas

Hello All, I'm experiencing significant read query blocking on Aurora PostgreSQL read replicas during VACUUM relation truncation, particularly with TOAST tables. This affects a high-traffic service (~3000 req/sec) and causes application downtime. *Problem Summary:* WAL replay of relation trunca

Re: WAL Replay Buffer Invalidation Conflicts During Page Truncation on Read Replicas

On 2025-Jul-08, Dharin Shah wrote: > *Problem Summary:* > WAL replay of relation truncation operations on read replicas triggers > buffer invalidation that requires AccessExclusive locks, blocking > concurrent read queries for extended periods. Hmm, sounds like disabling truncate of the TOAST r