Dmitry Koterov escribió:
> I have written in C all needed contrib functions: intarray.bidx() (binary
> search in sorted list) and intagg.int_agg_append_state (bufferized appending
> of one array to another without linear memory reallocation). The speed now
> is great: in one case with intersection of 100000 and 15000 arrays it become
> 30ms instead of 1600 ms (50 times faster).
>
> Few days later, after complex testing, I'll publish complete patches in
> pgsql-hackers maillist.
Did you already?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support