Tunning: Odoo 9 and PostgreSQL 9.4

This configuration may not suit for every needs

Default Odoo 9 installation folder:

• /usr/lib/python2.7/dist-packages/openerp/
• /usr/lib/python2.7/dist-packages/openerp/addons/

Edit /etc/odoo/openerp-server.conf

...
max_cron_threads = 1
...

Edit /etc/postgresql/9.4/main/postgresql.conf

...
# - Memory -
shared_buffers = 8192MB                 # min 128kB
                                        # (change requires restart)
...
# - Checkpoints -
#checkpoint_segments = 3                # in logfile segments, min 1, 16MB each
checkpoint_segments = 32                # 512MB https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
...
# - Planner Cost Constants -
#effective_cache_size = 4GB
effective_cache_size = 8GB
...
Note:

• shared_bufferes = 1/4 physical memory
• effective_cache_size = 1/2 physical memory

References:

• https://www.odoo.com/documentation/9.0/setup/deploy.html
• https://www.postgresql.org/docs/current/static/runtime-config-resource.html
• https://github.com/osiell/ansible-odoo/issues/42
• https://www.odoo.com/es_ES/forum/ayuda-1/question/could-not-obtain-lock-on-row-in-relation-ir-cron-74519
• https://github.com/QuantumObject/docker-odoo/issues/8
• https://github.com/odoo/odoo/issues/5459