Community mailing list archives

Re: How to optimize general performance

Camptocamp France SAS, Alexandre Fayolle - Camptocamp
- 02/07/2016 04:25:23
Odoo is clearly OLTP.

Regarding memory: if there are 8 cores, plan for 8 workers, and configure a hard limit of 4GB per worker. This means 32GB for Odoo, say 40. You may assign ~64GB for postgresql.

2016-02-05 22:34 GMT+01:00 Andreas Becker <>:
+ Kitti

What would be best to set:

Web application
Online transaction processing system
Data warehouse
Mixed type of applications

what is your experience?

How many connections would be best?

Total Memory - does it mean all memory of the system or if you run also other applications on the server which use. i.e. mariaDB or MySQL etc.only the memory you would like to give to postgres?

With kind regards,
Mit freundlichen Grüßen,
Con un cordial saludo,
с сердечным приветом,


CEO/General Manager LisAndi Co., Ltd.


LisAndi Co. Ltd., Phuket, Thailand (
15/21 M.2 Viset Road, Rawai, Muang, Phuket, Thailand 83130

VoIP:   +49 (0)711 50 88788 50
Fax:     +49 (0)711 50 88788 50
Skype:          lisandi
Facebook:     andibecker
Google Talk/Facetime/eMail:


This email may contain confidential and/or privileged information. If you are not the intended recipient (or have received this email by mistake), please notify the sender immediately and destroy this email. Any unauthorized copying, disclosure or distribution of the material in this email is strictly prohibited. Email transmission security and error-free status cannot be guaranteed as information could be intercepted, corrupted, destroyed, delayed, incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which may arise as a result of email transmission

On Sat, Feb 6, 2016 at 12:17 AM, Naresh Soni <> wrote:
+1 Kitti, very useful website.

Naresh Soni
Founder and Consultant
Cozy Business Solutions Pvt. Ltd
+91 8866 370537

On 5 February 2016 at 19:42, Kitti U. <> wrote:

There is this website that we use,


On Fri, Feb 5, 2016 at 7:22 PM, Lionel Sausin <> wrote:
The 2 most simple, quick efficient things to tune are :
- enable workers in the Odoo config, so you can use your multi-core CPU
- configure Postgresql with PGTune, which will set sensible values for 
your hardware

Post to:

Mobile: +66-(0)8-1841-7480
Your ERP Partner =>

Post to:

Post to:

Post to:

Alexandre Fayolle
Chef de Projet
Tel : + 33 (0)4 58 48 20 30

Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac Cedex