Contributors mailing list archives
contributors@odoo-community.org
Browse archives
Re: Postgres Optimisation
by
Leonardo Pistone
On Fri, Nov 20, 2015 at 6:23 AM, Andreas Becker <andi@lisandi.com> wrote: > If you have such a request simply point the people to the correct place so they can find these things immediately and the discussion will stop itself. Please, stop accusing people of things that are not true. Nhomar gave a precise answer, twice, which included, among other things, the official postgresql documentation. It is found in http://www.postgresql.org/docs. Moreover, Graeme and Ray gave extensive answers, too, and the already mentioned talk by Olivier Dony is very good. I share Nhomar and Graeme's point. - I think rewriting all the documentation of postgresql, going through every feature and option, for odoo is the wrong approach. The original documentation of postgresql is the best place, and it is excellent. - check out Olivier Dony's talk for advice specific to Odoo - with recent postgresql start with defaults (+ Olivier's advice) - there isn't a "perfect" copy-paste configuration of Odoo. If you have performance problems, copy-paste won't help, but instead you need some analysis, checking your blocked and long queries, indexes, 'explain analyze' and so on. This knowledge is not at all odoo-specific: you can study the postgresql documentation, hire an expert, or both. - No, I do not mean "hire me".
