How not to use jsonb fields and their indexes in #PostgreSQL vsevolod.net/postgresql-jso Also JIT shenanigans.
Conversation
Btrees are awesome. Is it theoretically possible to have something like btrees for arrays in PostgreSQL? To treat each element from an array like a separate value
2
Replying to
I think that the array GIN operator class is exactly what you're looking for. An int array becomes an integer B-Tree in the GIN index, for example. This can be used to speed up queries with the array "contains" operator. Stuff like that.
Replying to
I know of this stuff, sadly it doesn't work for my use case. I have an extended explanation in the linked post in this thread. And `@>` has its own set of problems, also explained in the post. Maybe I should write to Postgres mailing list?