Re: select count(id) on RDS replica causing high CPU load on RDS master

2020-06-04 Thread Azul
Thanks Jeremy, Plan is on the cards to upgrade to 10 this or next week, and then later on towards v12. hot_standby_feedback is enabled, yes. So the process list only shows high cpu usage for the postgres process itself, and all other ones are < 1.5%. it's a bit baffling as I don't have anything he

select count(id) on RDS replica causing high CPU load on RDS master

2020-06-03 Thread Azul
Hi sweeties, I'm a bit confused about this one, and could use some help from you PG overlords, so I have a RDS 9.5 master 16vcpu/64GB RAM/5000 IOPS which is RDS replicating to a replica with the same specs. The load on the master is roughly 20/30% cpu and there's only some batch queries running o