yugabyte-db icon indicating copy to clipboard operation
yugabyte-db copied to clipboard

[YSQL] Support multicolumn GIN indexes

Open jaki opened this issue 3 years ago • 1 comments

Jira Link: DB-892

jaki avatar Nov 19 '21 04:11 jaki

Currently, amroutine->amcanmulticol = false. This means that gin indexes can only index a single column, not multiple columns. There's also amroutine->amcaninclude = false, but that is a limitation with upstream postgres as well.

Note that the btree_gin extension is most useful with multicolumn because it allows gin indexed columns to be alongside regular indexed columns.

keywords: multi-column multi column btree btreegin btree_gin btree-gin extension

jasonyb avatar Jul 19 '22 16:07 jasonyb