Eric Brison 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 ar
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.
I found that i can use the "arraycontains" builtin function for int[] with
null values. Bu
Eric Brison writes:
> I use tables with several "int[]" columns.
> I use the "@>" operator to filter my data.
> To increase speed , i install the "intarray" extension. Now queries are
> very fast with the specific indexes (i use "gin__int_ops").
> But, in few columns, i have null values in my inta
Hello,
I use tables with several "int[]" columns.
I use the "@>" operator to filter my data.
To increase speed , i install the "intarray" extension. Now queries are
very fast with the specific indexes (i use "gin__int_ops").
But, in few columns, i have null values in my intarray and i cannot use
