Technical mailing list archives
Re: Deploying Odoo on 2 serversby
NUMERIGRAPHE, Lionel Sausin
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.