Hi Odoo Community,

We are trying to better understand real-world challenges in running and optimizing Odoo, especially from a database performance perspective.

One area we are particularly interested in is PostgreSQL configuration and tuning for Odoo workloads.

From a user perspective:

* Have you faced performance issues in Odoo that were later linked to PostgreSQL configuration settings?

* Do you find it difficult to decide optimal values for parameters like memory usage, parallel workers, or caching?

* In your experience, does Odoo performance vary significantly depending on how well PostgreSQL is tuned?

We understand that:

* PostgreSQL provides many configuration options (memory, workers, caching, etc.)

* Proper tuning can significantly improve performance

* However, tuning often requires deep knowledge and can be time-consuming or confusing

We would like to understand:

* Have you manually tuned PostgreSQL for your Odoo deployment?

* If yes, what parameters made the biggest difference?

* Did you rely on any tools, guides, or trial-and-error to achieve better performance?

We are also exploring whether database-level improvements could simplify this process.

One idea is to automatically adjust PostgreSQL configuration based on:

* Server specifications (CPU, RAM, storage)

* Typical Odoo workload patterns (ORM usage, relational queries, read/write mix)

So we would like to ask:

* Would you find value in an automatic tuning system that optimizes PostgreSQL settings for Odoo?

* Would you trust such a system if it significantly reduces the need for manual configuration?

Your feedback and real-world experiences will help us understand how common this challenge is and what kind of solution would be most useful.

Thank you!