Skip site navigation (1) Skip section navigation (2)

Re: Array performance

From: Ruben Rubio Rey <ruben(at)rentalia(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Array performance
Date: 2006-03-27 07:03:03
Message-ID: 44278E27.5090909@rentalia.com (view raw or flat)
Thread:
Lists: pgsql-performance
Tom Lane wrote:

>Ruben Rubio Rey <ruben(at)rentalia(dot)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[]

In response to

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2006-03-27 12:14:07
Subject: Re: experiences needed - how does Itanium2/1.5GHz(4MB) compare to AMD and Intel CPUs as far as Postgresql is concerned
Previous:From: Tomaz BorstnarDate: 2006-03-25 19:11:22
Subject: experiences needed - how does Itanium2/1.5GHz(4MB) compare to AMD and Intel CPUs as far as Postgresql is concerned

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group