Quick Answer
If your Odoo ERP feels slow, the problem is rarely the software itself—it's almost always the configuration. These 5 quick fixes can double your Odoo performance without writing a single line of code: enable multiprocessing workers, tune PostgreSQL with PGTune, uninstall unused modules, configure Nginx Gzip compression, and vacuum your database regularly.
Introduction: Speed is a Feature
An ERP that lags is an ERP that users hate. Research shows that if a page takes longer than 2 seconds to load, employee productivity drops by 20%, and frustration spikes.
If your Odoo system feels "heavy," the problem is rarely the software itself—it's almost always the configuration. Out of the box, Odoo is set up for compatibility, not raw speed.
In this guide, we will walk you through 5 technical quick fixes that can double your Odoo performance without writing a single line of code.
Fix #1: Enable Multiprocessing (The "Workers" Rule)
The most common reason for slowness is running Odoo in "threaded" mode instead of "multiprocessing" mode.
By default, Odoo might run on a single process. You need to tell it to use all your CPU cores.
The Fix:
Step 1: Open your odoo.conf file (usually located in /etc/odoo/)
Step 2: Locate the workers line
Step 3: Calculate your optimal number using this formula: (CPU Cores × 2) + 1
Example: If you have 4 Cores, set workers to 9
Recommended Memory Limits:
limit_memory_hard = 2684354560 # 2.5GB
limit_memory_soft = 2147483648 # 2.0GB💡 Pro Tip: Not comfortable editing server files? Braincuber's DevOps team can tune your server in a 15-minute session.
Fix #2: Tune PostgreSQL with PGTune
Odoo is the car, but PostgreSQL is the engine. If the engine is choked, the car won't drive fast.
Default PostgreSQL settings are designed for tiny laptops, not enterprise servers.
The Fix:
Step 1: Go to the PGTune website (a free tool)
Step 2: Enter your server details (RAM, CPU, Type = "Online Transaction Processing")
Step 3: Copy the generated configuration
Step 4: Paste it into your postgresql.conf file
Key Setting to Check:
⚠️ Warning: Database tuning is risky if done wrong. Let Braincuber's DBAs optimize your PostgreSQL safely.
Fix #3: Uninstall Unused Modules
Every installed module adds overhead to the system registry, even if you don't use it.
Did you install "Gamification" or "Website" just to look at them? They are slowing down your boot time and increasing memory usage.
The Fix:
Step 1: Go to Apps
Step 2: Filter by Installed
Step 3: Identify modules you have never used
Step 4: Click Uninstall
⚠️ Warning: Never uninstall standard "base" modules without expert advice. If you aren't using it, remove it—but be cautious with core dependencies.
Fix #4: Configure Nginx Gzip Compression
Reduce the size of data traveling between the server and your browser.
If your Odoo is hosted on the cloud (AWS, DigitalOcean), the latency usually comes from transferring large Javascript/CSS files. Gzip compresses them by up to 70%.
The Fix:
Step 1: Open your Nginx configuration file (/etc/nginx/sites-enabled/default)
Step 2: Add the gzip_types block to compress text, XML, JSON, and CSS
Nginx Gzip Configuration:
gzip on;
gzip_types text/css text/less text/plain text/xml
application/xml application/json
application/javascript;💡 Pro Tip: Need help configuring your Nginx Reverse Proxy? Braincuber's support team can set this up quickly.
Fix #5: Vacuum Your Database (The "Spring Cleaning")
Over time, PostgreSQL accumulates "dead tuples"—data that has been deleted but still takes up space.
This "bloat" makes every search query scan through junk data before finding the real result.
The Fix:
Step 1: Open pgAdmin or your terminal
Step 2: Run the VACUUM FULL command on your production database
⚠️ Note: This locks tables, so do it during the weekend or scheduled maintenance window!
Command to Run:
VACUUM FULL;Regular maintenance keeps your query speeds fast.
Performance Quick Reference
| Fix | Impact | Difficulty | Time Required |
|---|---|---|---|
| Enable Multiprocessing | 🔥 High | Medium | 15 mins |
| Tune PostgreSQL | 🔥 High | Medium | 30 mins |
| Uninstall Unused Modules | ⚡ Medium | Easy | 10 mins |
| Nginx Gzip Compression | ⚡ Medium | Medium | 20 mins |
| Vacuum Database | ⚡ Medium | Easy | 5 mins |
Frequently Asked Questions
Why is my Odoo slow after importing data?
Massive data imports can fragment indexes. After any large import, you must run a "Reindex" command on your PostgreSQL database to resort the data for fast retrieval. This reorganizes the data structure for optimal query performance.
How much RAM do I need for 50 Odoo users?
For 50 concurrent users, we recommend at least 16GB of RAM and 4 CPU Cores. A general rule is allowing ~200MB of RAM per concurrent worker. This ensures smooth operation during peak usage times.
Is Odoo.sh faster than On-Premise?
Not necessarily. Odoo.sh is optimized for convenience and stability. A well-tuned On-Premise server (like AWS EC2) can often be faster because you have full control over the hardware and PostgreSQL config, whereas Odoo.sh has fixed limits per worker.
How often should I vacuum my PostgreSQL database?
For active Odoo installations, run VACUUM ANALYZE weekly and VACUUM FULL monthly during maintenance windows. High-transaction databases may need more frequent maintenance. Braincuber recommends setting up automated vacuum schedules.
What is the optimal number of Odoo workers?
Use the formula: (CPU Cores × 2) + 1. For a 4-core server, set workers to 9. Also allocate 1-2 workers specifically for cron jobs. Monitor your server's CPU and memory usage to fine-tune this setting for your specific workload.
Conclusion: Performance is a Continuous Process
Speed isn't a "set it and forget it" task. As your database grows, your configuration must evolve. These 5 fixes will solve 80% of performance issues, but if you are still experiencing lag, you may have "slow queries" in your custom code.
Still Stuck with a Slow System?
Don't let lag kill your team's productivity. At Braincuber Technologies, we guarantee to improve your Odoo speed or you don't pay.
Let's make your Odoo fly.
Book a Free Performance Audit
Our experts will analyze your Odoo setup, identify bottlenecks, and provide a roadmap to double your system speed—guaranteed.
No obligation • Expert analysis • Speed guarantee