Community mailing list archives
Re: How to optimize general performanceby
What would be best to set:
Online transaction processing system
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?
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.--