B-Tree isn't your only index. GIN handles arrays but pays on every write, and BRIN only helps when rows are physically ordered, like timestamps. Picking the wrong one is why your query is still slow. go.fastruby.io/lgj #PostgreSQL

0 likes 0 replies