GIN Indexes in PostgreSQL
If you come from SQL Server (like in my case), PostgreSQL indexing can feel familiar at first – B-tree indexes exist, composite indexes exist, covering indexes exist. And then you run into queries like this: or this: At that point, most SQL Server developers ask two questions: What are these operators? Why does PostgreSQL need …
