Performance Issues with High Insert Rate and Lock Accumulation in PostgreSQL Cluster with TimescaleDB
I have a PostgreSQL cluster composed of four machines, configured as follows: Three PostgreSQL nodes managed by Patroni and ETCD, using PgBouncer. One of these nodes is the primary, and the other two are replicas. One machine using HAProxy to…