Easy Steps To Optimize The Odoo Server With PostgreSQL

Posted By : Anirudh Bhardwaj | November 14, 2022

Odoo is one of the most sought-after ERP software platforms that is extensively used by a large number of businesses worldwide. Being an open-source suite of business applications, it caters to the diverse industry-specific needs of enterprises through a series of modules including CRM, accounting, inventory/WMS, and more. The Odoo modules are fully customizable, flexible, interoperable, and easy to scale. Thus, it enables enterprises to gain full control over the software and its features by customizing it as per their current needs and requirements. 

From a developer’s standpoint, Odoo is relatively easier to learn and implement with the choice of customization. Besides, it supports all major operating systems including Linux, Unix, macOS, Windows, Android, and iOS, with Linux being the most recommended OS. 

 

Also, Read Introducing Odoo 16: The New and Enhanced ERP Software Suite

Easy Steps To Optimize The Odoo Server With PostgreSQL

 

Optimizing The Odoo Server

In this blog post, we shall learn about optimizing the Odoo server to boost the performance of your Odoo application. Subsequently, we shall explore the basic steps to optimize buffer and cache size in PostgreSQL. 

 

Setting Up Worker and Memory Limits

Use the following command to open up the configuration file of your Odoo instance.

nano /etc/odoo-live.conf

 

Note: In place of odoo-live, give a relevant Odoo instance name.

 

Set the following fields as given below:

workers keep the number of workers equal to the number of CPU cores allocated to the VPS i.e (CPU cores * 2) + 1.

Here, there are 13 workers for 6 CPU cores. You may set the value lower if CPU resources are to be allocated for other processes. 

While setting up memory limits, we must also take other applications into consideration as well. As such, the combined formula would be = (Total available RAM – RAM allocated for other applications) / Worker Count.

For instance, the ideal configuration for a system with 6 CPU cores and 16GB RAM would be as follows:

workers = 13

limit_memory_hard = 1208MB

limit_memory_soft = 1024MB

Once you are done with the above steps, restart Odoo using the following command on your terminal:

sudo service odoo-live restart

 

 

Also, Read Leveraging Odoo SaaS ERP For Business Process Management

 

PostgreSQL Database 

Here, you will learn how to optimize buffer and cache size in PostgreSQL.

Use the following command to open up the configuration file of your PostgreSQL installation: 

/var/lib/postgresql/data/postgresql.conf

 

Note: The directory name inside /var/lib/ may vary depending on your system.

Now set the following fields:

  • shared_buffers – it refers to the amount of RAM allocated for PostgreSQL and is equivalent to (The total available RAM * 0.2).
  • effective_cache_size – it refers to the amount of disk space available for PostgreSQL cache which happens to be the temporary data. It should be equivalent to (the total available RAM * 0.5).

For instance, the configuration for a system with 16GB RAM should be as follows:

shared_buffers = 3072MB

effective_cache_size = 8192MB

Once through with the above steps, restart PostgreSQL using the following command:

sudo service postgresql restart

 

You may also like to read Odoo ERP Application Development For Travel and Tourism

 

Conclusion

Here, we have learned the process of optimizing the Odoo server and PostgreSQL to boost the performance of an Odoo application. To achieve better performance for an Odoo application with a PostgreSQL database, it is advisable to enhance the speed of RAM, CPU, and I/O while also increasing the speed and number of cores. Doing that would help improve the performance or even update to the latest PostgreSQL version at the time it is rolled out by the latter. If you have any further queries regarding the process of optimizing the Odoo server with PostgreSQL, let us know in the comments below.

 

Why Choose Oodles ERP For Odoo Application Development?

We are a trusted name in the ERP industry with ample experience in developing and implementing custom enterprise solutions from the ground up. Our ERP experts holistically analyze your business requirements and existing software model to formulate effective software implementation and execution strategies. We specialize in using Odoo and other open-source software suites like ERPNext, OFBiz, and Opentaps to build scalable business applications from scratch. To learn more about our Odoo application development services, contact us at [email protected]

guest
0 Comments
Inline Feedbacks
View all comments

Latest Blogs