Has anyone gotten pg-Bouncer or Pg-Pool-II, to work with Odoo? We tried and it did not work. Pooling, failover, read/write splitting will not work with these proxies because: 

• Odoo requires data consistency

• Odoo queries are in transactions

Has anyone tried the Heimdall Database proxy? https://www.heimdalldata.com/odoo

It supports Query Caching, Automated Failover, Read/Write split with ACID compliance. It was designed especially for Odoo. Would love to get your thoughts.