From: | Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr> |
---|---|
To: | Claire McLister <mclister(at)zeesource(dot)net> |
Cc: | Özgür Tuğrul <ozgur(dot)tugrul(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: stored function - array parameter - how many element in array ? |
Date: | 2006-07-14 06:28:58 |
Message-ID: | 20060714062858.GA1585@alamut.tdm.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Jul 13 08:28, Claire McLister wrote:
> Have you considered using a set instead? We had a similar need and
> were using an array as a parameter. That turned out to be taking too
> long. Recently we have changed it to a set and it seems to work
> faster, although I must admit I haven't timed it yet.
Did you experience same results when you use an indexable (integer)
array type supplied by intarray contrib module? Furthermore, there're
lots of useful procedures and operators which supplies any kind of
functionality you'll ever need with arrays. Also it's obviouse that
there's no need to tell that these libraries are written in C with quite
optimized algorithms.
Regards.
From | Date | Subject | |
---|---|---|---|
Next Message | Florian Weimer | 2006-07-14 07:27:23 | Re: Timestamp vs timestamptz |
Previous Message | Michael Glaesemann | 2006-07-14 05:11:18 | Re: Timestamp vs timestamptz |