Oleg Bartunov wrote:
>
> We finished (cross fingers) our changes in GiST code for 7.0.3
Are tha patches for 7.0.3 already available ?
> and in next 2 days we plan to send patches for upcoming 7.1 release.
> Isn't this too late ? What else we need to submit ?
> We have int4array contribution package which added index support for
> integer arrays
what exactly does it mean ?
can i now query for an int4array which contains number 42 or just
an int array that = '{1,2,3}' with index support ?
> and it's probably should come to contrib directory.
> We got about 3 orders of magnitude speedup using RD-Tree.
> Probably we need to add regression test for GiST.
Some samples will do fine for start ;)
> We have following fixes for GiST (7.0.3):
> 1. indices now store on disk in compressed form - was decompressed which
> causes broken index when using compression function
> (now compression of indices is really works)
> 2. NULLs now don't broken index
> 3. added support for keys with variable length - was fixed-length
>
> Patches and contribution package could be prepared in several days,
> documentation with some benchmarks and blurbs require more time.
> We plan to use these last changes to speedup our full-text-search
> ( killer application ) and write article to popularize GiST+Postgres.
> Any thoughts ?
Great!
-------
Hannu