Re: First version of multi-key index support for GiST

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: pgsql-hackers(at)postgresql(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: First version of multi-key index support for GiST
Date: 2001-05-27 03:46:41
Message-ID: 200105270346.f4R3kf510353@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Your patch has been added to the PostgreSQL unapplied patches list at:

http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it withing the next 48 hours.

[ Charset KOI8-R unsupported, converting... ]
> We have implemented multi-key index support for GiST. Patch is available
> from http://www.sai.msu.su/~megera/postgres/gist/code/7.1.2/patch_multikeygist.7.1.2.gz
> The patch could be applied for postgresql version 7.1.2 and current sources 7.2
>
> 1. initdb is required. But, it's possible just to execute update
> update pg_am set amstrategies = 12 where amname = 'gist';
>
> 2. You have to recompile all gist_*_ops functions
>
> 3. multi-key indexes works only for ??? gist__int_ops and
> gist__intbig_ops (from contrib/intarray), because they have
> support for NULLs.
>
> As a bonus we fixed several memory leaks in old GiST code.
>
>
> Example:
>
> create index mgix on tabletest using gist (b gist_int_ops, a
> gist__intbig_ops ) with ( islossy );
>
>
> Regards,
> Oleg
> _____________________________________________________________
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2001-05-27 08:32:54 RE: Plans for solving the VACUUM problem
Previous Message Adam Haberlach 2001-05-27 02:00:44 Re: Parser abort ignoring following commands