Received: from me.tm.ee (adsl895.estpak.ee [213.168.23.133]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBL9Fj691860 for ; Thu, 21 Dec 2000 04:15:45 -0500 (EST) (envelope-from hannu@tm.ee) Received: from tm.ee (IDENT:hannu@localhost.localdomain [127.0.0.1]) by me.tm.ee (8.9.3/8.9.3) with ESMTP id LAA01057; Thu, 21 Dec 2000 11:12:41 +0200 Message-ID: <3A41C989.6E83D1E@tm.ee> Date: Thu, 21 Dec 2000 11:12:41 +0200 From: Hannu Krosing X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.17 i686) X-Accept-Language: en MIME-Version: 1.0 To: Oleg Bartunov CC: Tom Lane , Bruce Momjian , PostgreSQL-development Subject: Re: Who is a maintainer of GiST code ? References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200012/880 X-Sequence-Number: 2409 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