Skip site navigation (1) Skip section navigation (2)

First version of multi-key index support for GiST

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: <pgsql-hackers(at)postgresql(dot)org>
Cc: <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: First version of multi-key index support for GiST
Date: 2001-05-26 12:33:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
We have implemented multi-key index support for GiST. Patch is available
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.


create index mgix on tabletest using gist (b gist_int_ops, a
                                     gist__intbig_ops ) with ( islossy );

Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su,
phone: +007(095)939-16-83, +007(095)939-23-83


pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-05-26 13:53:24
Subject: Re: First version of multi-key index support for GiST
Previous:From: Tom LaneDate: 2001-05-26 05:26:39
Subject: Re: Hanging VACUUM

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group