Re: Array performance

Tom Lane wrote:

>Ruben Rubio Rey <ruben@rentalia.com> writes:
>  
>
>>SELECT (array[20]+array[21]+ ... +array[50]+array[51]) as total
>>FROM table
>>WHERE
>>(array[20]+array[21]+ ... +array[50]+array[51])<5000
>>AND array[20]<>0
>>AND array[21]<>0
>> ...
>>AND array[50]<>0
>>AND array[51])<>0
>>
>Any ideas to make this query faster?
>  
>
>
>What's the array datatype?  Integer or float would probably go a lot
>faster than NUMERIC, if that's what you're using now.
>  
>
Already its integer[]