odoo-performance-tuner

# Odoo Performance Tuner ## Overview This skill helps diagnose and resolve Odoo performance problems — from slow page loads and database bottlenecks to worker misconfiguration and memory bloat. It covers PostgreSQL query tuning, Odoo worker settings, and built-in profiling tools. ## When to Use This Skill - 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. ## How It Works 1. **Activate**: Mention `@odoo-performance-tuner` and describe your performance issue. 2. **Diagnose**: Share relevant log lines or config and receive a root cause analysis. 3. **Fix**: Get exact configuration changes with explanations. ## Examples ### Example 1: Recommended Worker Configuration ```ini # odoo.conf — tuned for a 4-core, 8GB RAM server workers = 9 # (CPU_cores × 2) + 1 — never set to 0 in production max_cron_threads = 2 # background cron jobs; keep ≤ 2 to preserve user-facing capacity limit_memory_soft = 1610612736 # 1.5 GB — worker is recycled gracefully after this limit_memory_hard = 2147483648 # 2.0 GB — worker is killed immediately; prevents OOM crashes limit_time_cpu = 600 # max CPU seconds per request limit_time_real = 1200 # max wall-clock seconds per request limit_request = 8192 # max requests before worker recycles (prevents memory leaks) ``` ### Exa...