Bug #20990
Updated by Peter Amstutz about 1 year ago
We added a trigram gin index on collection 'name' in #14070 Specifically on https://dev.arvados.org/issues/14070#note-12 we decided that we only needed the trigam gin index because the postgres documentation it stated it could would be used for the "=" operator. However, on a user cluster, that it doesn't seem to be true. Explain used for equality, explain analyze has '=' it doing a parallel seq scan. So we need to add a btree index on 'name' anyway.