Replication Slots filling up disk?
Even if you specify use_slots in Patroni's configuration, the slot will be automatically removed if the replica fails to renew it's member key in the DCS (distributed consensus store). By default this means a slot for a disappeared replica will be dropped after 30 seconds (this corresponds to the ttl setting, which ...
You can fail over to a readable secondary. The author is either wrong, or just using some confusing terminology. Reading the exact quote you included, I'd lean towards the former explanation. But I don't know all the context around that statement.
Here I have an AG - all replicas are configured to be readable when they are in the secondary role, and NODE2 ...
I see the list of all the operations that can trigger a scan but none of them are happening on my machine, is there a way to tell what causes the scan?
It's a CHECKPOINT on database ID 8. It says so right in the message.
Do you have INDIRECT CHECKPOINT enabled? What does
select database_id , name, target_recovery_time_in_seconds