Eric Brison <eric.bri...@anakeen.com> writes: > yes i a have a specific query with many rows and big int array These data > not contains null values. And in this case , i use the specific GIN index. > The query time decrease from 30s to 100ms with the index.
My point is that you can also make a gin index on an integer array
using the built-in array opclass. It might be a shade slower than
intarray, but maybe it's 120ms instead of 100, and it'll handle
nulls correctly.
regards, tom lane
