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

# 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
lim