Received: from golem.pgsql.com (w148.z064003068.lax-ca.dsl.cnc.net [64.3.68.148]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBL5bn666825 for ; Thu, 21 Dec 2000 00:37:49 -0500 (EST) (envelope-from lockhart@alumni.caltech.edu) Received: from alumni.caltech.edu (localhost.localdomain [127.0.0.1]) by golem.pgsql.com (Postfix) with ESMTP id 98BE917C5E; Thu, 21 Dec 2000 06:00:57 +0000 (UTC) Message-ID: <3A419C99.934EEFA4@alumni.caltech.edu> Date: Thu, 21 Dec 2000 06:00:57 +0000 From: Thomas Lockhart Organization: Yes X-Mailer: Mozilla 4.73 [en] (X11; I; Linux 2.2.15-4mdksmp i686) X-Accept-Language: en MIME-Version: 1.0 To: Oleg Bartunov Cc: Tom Lane , Hannu Krosing , 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/873 X-Sequence-Number: 2402 > We finished (cross fingers) our changes in GiST code for 7.0.3 > 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 ? Not too late, especially if it is fixing bugs. And even if not, anything we can do to encourage active development and use of GiST is worth the effort imho. I'll guess that unless we are talking about some extreme, far-reaching changes in the backend others will agree. > We have int4array contribution package which added index support for > integer arrays 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. > 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 ? Go go go !!! :) - Thomas