Eric Brison <eric(dot)brison(at)anakeen(dot)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