3 ms·
Expression indexes are nice, and you can still do that. It however requires you to know what you'll be looking for (and create index on that particular expressi
by tomiko_nakamura 12y ago
Expression indexes are nice, and you can still do that. It however requires you to know what you'll be looking for (and create index on that particular expression).
The stuff I find really awesome is indexing for arbitrary expressions:
CREATE INDEX jsonb_index ON jsonb_table USING GIN (jsonb_column);
And then you can where whatever key/value you want, and it'll use the index.