Re:What PostgreSQL has over other open source SQL databases:...
by Veratyr on Monday October 26, 2015 @12:00AM
(#10449539)
Hmm, I don't know much about it either and it looks like you're right. I don't believe that querying it is nearly as fast as querying a GIN index (or as easy) still.
With Postgres I just do this and it gives me a result in a couple ms:
SELECT * FROM things WHERE ARRAY['tag1', 'tag2'] <@ tags;
With Postgres I just do this and it gives me a result in a couple ms: