Technical mailing list archives

Re: unused database indexes

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:

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

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