Technical mailing list archives

Re: Deploying Odoo on 2 servers

- 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.