BRIN indexes seem useful, but I'm not sure how to use one on an ENUM type. I thought this code would work:
CREATE TYPE test_enum AS ENUM ('a', 'b'); CREATE TEMPORARY TABLE my_table ( x test_enum ); CREATE INDEX test_index ON my_table using brin (x); ERROR: data type test_enum has no default operator class for access method "brin"
Do I have to create a new operator class from scratch? Aren't enums already ordered?
This commit, from 2014, implies that BRIN indexes should work for ENUM types.