Eric Brison <eric.brison@xxxxxxxxxxx> 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
