How to Properly Load Balance Write Functions With Pgpool
Pgpool-II is a middleware that resides between PostgreSQL servers and clients. It can handle connection pooling, replication, and load balancing. Specific procedures or functions used in SELECT statements can make write operations while reading, and pgpool load balancer needs to configured to deal with such functions.