Community mailing list archives
Re: How to optimize general performanceby
Camptocamp France SAS, Alexandre Fayolle - Camptocamp
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 <firstname.lastname@example.org>:
+ KittiWhat would be best to set:Web applicationOnline transaction processing systemData warehouseDesktopMixed type of applicationswhat 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?On Sat, Feb 6, 2016 at 12:17 AM, Naresh Soni <email@example.com> wrote:+1 Kitti, very useful website.On 5 February 2016 at 19:42, Kitti U. <firstname.lastname@example.org> wrote:Hello,There is this website that we use, http://pgtune.leopard.in.ua/KittiOn Fri, Feb 5, 2016 at 7:22 PM, Lionel Sausin <email@example.com> 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 LS.--