Community: Framework mailing list archives

expert-framework@mail.odoo.com

Re: unused database indexes

by
Camptocamp France SAS, Alexandre Fayolle - Camptocamp
- 07/28/2016 03:09:05
On 27/07/2016 17:01, Leonardo Rochael Almeida wrote:

> Another point raised in the original thread was the fact that most CHAR
> field indexes are useless since most searches on these fields are
> through LIKE and ILIKE operators.
> 
> For these cases, we could be using trigram indexes:
> 
> https://www.postgresql.org/docs/current/static/pgtrgm.html
> 

Careful evaluation of trigram indexes should be done. I'm concerned of
the cost of these, both disk-wise and CPU-wise for the often updated
tables.

-- 
Alexandre Fayolle
Chef de Projet
Tel : +33 4 58 48 20 30

Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac Cedex
http://www.camptocamp.com