Re: How to speedup intarray aggregate function? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: How to speedup intarray aggregate function?
Date
Msg-id 20071023135509.GL5772@alvh.no-ip.org
Whole thread Raw
In response to Re: How to speedup intarray aggregate function?  ("Dmitry Koterov" <dmitry@koterov.ru>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: autovacuum and locks
Next
From: Tom Lane
Date:
Subject: Re: Bitmap Heap scan 8.1/8.2