Community mailing list archives

Re: How to optimize general performance

Open For Small Business Ltd, Graeme Gellatly
- 02/07/2016 10:05:18

Tbh Alex I do it slightly differently. Hard limit around 12gb, soft limit at 2gb. That way really big batch processes complete, but run of the mill requests don't take a lot of ram.  That's with 25 workers and ram usage for python rarely exceed 20gb. But of course monitoring logs is really the only way to tune that to a specific workload.  Although I'm wondering now if restarting workers clears cache and a higher soft setting may be better.

In terms of postgres I pretty much use the setting you suggest but I think it's largely ignored in recent versions except by the query planner.  But it's what pgtune spits out anyway.

On Sun, 7 Feb 2016 10:27 PM Alexandre Fayolle <> wrote:
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


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


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

Post to: