Community mailing list archives
Re: How to optimize general performanceby
Your RDS is really a micro instance, probably why. PostgreSQL is the core technology that binds Odoo performance and it needs the resources.
Senior Odoo Consultant | 909.864.4576 | Skype: bista_ray
Time zone: US Pacific | Office: Greater Los Angeles
Bista Solutions, Inc. | Empowering Business Success
From: Alejandro Perez
Sent: 2/10/2016 8:17 AM
Subject: Re: How to optimize general performance
We are also having some performance problems right now.
We have 5 physical POS with 4000 products which are loaded at the same time (7:30 am) for 5 sessions.
The server specs: EC2 m4.xlarge (4 vCPU and 16GB Mem) + RDS db.t2.small (1 vCPU and 2GB Mem)
The stores have 20Mb/s internet connection.
The thing is the POS sessions take 10 minutes or more to load the products and some times the server crashes while loading (100% processor use while products are being loaded)..
The odoo config file was not edited.
Is this an expected behavior?
I really don't understand how these loads can crash a server with such specs..
On 07/02/16 11:08, Graeme Gellatly wrote:
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 <firstname.lastname@example.org> 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 <email@example.com>:
What would be best to set:
Web applicationOnline transaction processing systemData warehouseDesktopMixed 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?
+1 Kitti, very useful website.
[The entire original message is not included.]