Recommendations to others considering Odoo Survey:
research more on the subject and be more concise in your answers and tell the truth. Review collected by and hosted on G2.com.
What problems is Odoo Survey solving and how is that benefiting you?
Many people think that performance problems in Odoo are solved by enlarging the servers on which the ERP runs. And although there is some virtue in that solution, it is like too much. Enlarging the server should be the last resort when attacking Odoo performance issues.
Most of the performance problems in Odoo are related to the PostgreSQL database, because it is badly configured. By default when installing Odoo, one installs PostgreSQL, and the database installation is done with a very conservative configuration. For example it does not benefit from the usual memory that a server has for caching purposes. Just tapping a few parameters in the postgresql.conf configuration file (such as shared_buffers and effective_cache_size) can make a noticeable improvement. Still, it is best to follow the performance guide in the Postgresql documentation.
Another related point is to vacuum the database. Once talking to a friend who had worked in technical support for Informix, he told me "PostgreSQL is very simple, you just vacuum and solve all the problems." While the comment is quite simplistic, there is much reason in his words. Many problems are solved with the vacuum. What is it? It basically "compresses" the database. It's the old "pack" of DBFs. What it does is physically delete the records (which can be many) "dead" that exist in the database.
Finally, you have to install pg_stat_statements. It is a contrib module for PostgreSQL that logs the statistics of each SQL statement that the database server executes. Then with a single query, you cannot know which are the statements that consume the most resources from the database.
While this is not a guide, it is the initial steps one takes to view perofrmance problems on an Odoo server. Then it remains to analyze the problematic modules, hardware, network, etc. Review collected by and hosted on G2.com.
