domains / families / devops / odoo-performance-tuner

odoo-performance-tuner

authentic

Expert guide for diagnosing and fixing Odoo performance issues: slow queries, worker configuration, memory limits, PostgreSQL tuning, and profiling tools.

When to use

• Odoo is slow in production (slow page loads, timeouts).
• Getting `MemoryError` or `Worker timeout` errors in logs.
• Diagnosing a slow database query using Odoo's profiler.
• Tuning `odoo.conf` for a specific server spec.

When not to use

• PostgreSQL tuning (`shared_buffers`, `work_mem`, `effective_cache_size`) is highly server-specific and not covered in depth here — use [PGTune](https://pgtune.leopard.in.ua/) as a starting baseline.
• The built-in Odoo profiler only captures **Python + SQL** traces; JavaScript rendering performance requires browser DevTools.
• **Odoo.sh** managed hosting restricts direct PostgreSQL and `odoo.conf` access — some tuning options are unavailable.
• Does not cover **Redis-based session store** or **Celery task queue** optimizations, which are advanced patterns for very high-traffic instances.

Skill page

Source