Hello,

We are on odoo v12 Enterprise. We have a number of third party apps, but they're all pretty robust, no major issues.

We also have not made any changes on our installation for a few weeks. Last Friday morning, all of the sudden we started experiencing extreme latency on standard actions that deal with inventory transfers. For example, "Check Availability" on pickings, or even Cancel for an order. It takes 60-90 seconds to load.

We have reset everything, uninstalled all 3rd party apps, and tried dozens of settings changes in postgresql and odoo configuration. The problem persists. The rest of the server is running great, it is only slow for inventory-related actions. If we create a new database on the same server, it works great. So, it seems that it is related to the database. Does anyone have any suggestions for things to try? We are pretty desperate.