Technical mailing list archives
Re: unused database indexesby
Used in production for 4 years. The cost is by far worth the benefit IMO. Multiple orders of magnitude faster searches on things like partner names, sale names, products, account moves. No noticeable write slow down. Use gin for master data, gist for stuff that changes regularly, although haven't tried gin on regularly changing data since they improved it's write speed.
The main issue for others will be lack of unaccent support as postgres treats unaccent as volatile by default. Idk what a standard Odoo index / data split looks like but ours is roughly 50 50.
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
Post to: mailto:firstname.lastname@example.org