Community: Framework mailing list archives

expert-framework@mail.odoo.com

Re: Deploying Odoo on 2 servers

by
NUMERIGRAPHE, Lionel Sausin
- 11/03/2014 03:38:52
Le 03/11/2014 09:12, Wolfgang Pichler a écrit :
>
> Hi all,
>
>
> from my experience with a  larger installation, i can propose that you 
> should tune your postgresql database schema a little bit. Odoo does 
> not seem to make always proper use of indexes. So adding some extra 
> indexes on the database does help a lot. Especially Odoo does a lot of 
> LIKE %VALUE% Searches. This type of search does make normal BTREE 
> based indexes helpless, you have to activate Trigram Indexes for this 
> type of searches.
>
> Just adding more processing power will also help, but it does often 
> not help as much as searching for the real bottleneck you have…
>
> br,
> Wolfgang
>
Would you care to name some of the fields which benefit most from this 
kind of index ?
Probably we could make a PR to have them created in the standard.
Lionel Sausin.