search

yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
https://www.yugabyte.com
Other
8.65k stars 1.04k forks source link

[YSQL] Support multicolumn GIN indexes #10652

Open jaki opened 2 years ago

jaki commented 2 years ago

Jira Link: DB-892

jasonyb commented 1 year ago

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