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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
