On Thu, Jun 18, 2026 at 02:07:36PM +0100, Thom Brown wrote: > Have you got anything in the logs that say "conflict with recovery"? > Also, I know you are just running count(*), but is there a transaction > being left open? > SELECT pid, state, xact_start, query > FROM pg_stat_activity > ORDER BY xact_start NULLS LAST; > Any 'idle in transaction' for too long? > What is max_standby_streaming_delay and hot_standby_feedback set to?
No transactions were happening then. These are our "Disaster Recovery" instances, and they are generally unused. max_standby_streaming_delay is 10 minutes hot_standby_feedback is on. Please note that these are *NOT* doing streaming replication! Best regards, depesz
