Support for covering indexes?

[michaelwu0505]

Hi,

Is there plan for rum index to support covering indexes [1]? Right now, when trying to create a rum index with INCLUDE, it will show:

ERROR: access method "rum" does not support included columns

The use case is that after rum index returns all possible matching rows, postgres can use the covering index to further filter the results by another column.

Thank you, Michael

[1] https://www.postgresql.org/docs/current/indexes-index-only-scans.html

[obartunov]

On Tue, 18 Feb 2020, 10:24 michaelwu0505, [email protected] wrote:

Hi,

Is there plan for rum index to support covering indexes [1]? Right now, when trying to create a rum index with INCLUDE, it will show:

ERROR: access method "rum" does not support included columns

The use case is that after rum index returns all possible matching rows, postgres can use the covering index to further filter the results by another column.

Unfortunately, we are very busy, but we have this on mind.

Thank you, Michael

[1] https://www.postgresql.org/docs/current/indexes-index-only-scans.html

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/postgrespro/rum/issues/78?email_source=notifications&email_token=ABQURYTLOSSQPBJP2QIKBMLRDOEJRA5CNFSM4KW6WKY2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4IOHDRRA, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABQURYXSBH52KLJK2TTUVH3RDOEJRANCNFSM4KW6WKYQ .