3 ms·
Be careful with trigram indexes. At least in the postgres 10 era they caused severe index bloat for frequently updated tables.
by semiquaver 3y ago
Be careful with trigram indexes. At least in the postgres 10 era they caused severe index bloat for frequently updated tables.
- peter_l_downs 3y agoInteresting, do you know anywhere I can easily read more about this? (I will do my own research, too.)
- boyter 3y agoIts a result of trigrams themselves. For example turning searchcode (please ignore plug, this is just the example I had to hand) goes from 1 thing you would need to index into 8. "searchcode" -> [sea, ear, arc, rch, chc, hco, cod, ode] As a result the index rapidly becomes larger than you would expect.