On Fri, May 27, 2022 at 3:01 PM Don Seiler wrote:
I've been reading tales of autovacuum taking an AccessExclusiveLock when
> truncating empty pages at the end of a table. I'm imagining that updating
> every row of a table and then rolling back would leave all of those rows
> empty at the end and
On Fri, 2022-05-27 at 14:00 -0500, Don Seiler wrote:
> * PostgreSQL 12.9 - PGDG Ubuntu 18.04 image
> * Streaming physical replication
> * hot_standby_feedback = on
> We use a read replica to offload a lot of (what should be) quick queries.
> This morning we had an incident
> where these
- PostgreSQL 12.9 - PGDG Ubuntu 18.04 image
- Streaming physical replication
- hot_standby_feedback = on
We use a read replica to offload a lot of (what should be) quick queries.
This morning we had an incident where these queries were all blocking on
AccessShareLock waits, written to