Hi Odoo Community,
We are trying to better understand real-world performance challenges in Odoo, especially around database efficiency.
One area we are curious about is index usage and potential overhead caused by unused indexes.
- Have you experienced performance issues related to slow writes (INSERT/UPDATE) in heavily used models?
- Have you ever investigated whether unused or rarely used indexes might be contributing to this slowdown?
- In databases with many installed addons, have you noticed a buildup of indexes that may not be actively used?
We understand that:
- Odoo (including addons) creates multiple indexes (commonly B-tree and GIN)
- Even if some of these indexes are not frequently used, they still add overhead to write operations
- This can impact performance, especially in models with high write activity
So we would like to ask:
- Have you ever manually identified or removed unused indexes in your Odoo database?
- If yes, what approach or tools did you use?
Additionally, would you find value in a system that:
- Periodically identifies unused or rarely used indexes
- Suggests or automatically removes them to improve performance
Your experiences and insights would help us understand whether this is a real-world problem and what kind of solution would be most useful.
Thank you!
