Re: GIST

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Greg Copeland <greg(at)CopelandConsulting(dot)Net>, PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: GIST
Date: 2002-03-19 11:46:54
Message-ID: Pine.LNX.4.43.0203191442140.10452-100000@zen.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Christopher,

I'm sorry it's too late, but I haven't receive any messages from
postgres mailing lists for a month (don't know why). Just found your
message in archives.

GiST is a great thing, it's generalised search tree invented by
Hellerstein in 1995. It allows you to define custom data type,
index access to them and custom queries.
I have a little intro about GiST (not finished yest)
http://www.sai.msu.su/~megera/postgres/gist/doc/intro.html
Also, at the bottom of http://www.sai.msu.su/~megera/postgres/gist/
there are several seminal papers for reading.

Regards,

Oleg

On Thu, 14 Mar 2002, Christopher Kings-Lynne wrote:

> > > Oh yes, one last question, is the required method for adding index
> > > support via GiST? I ask because it seems to me that inserts could be
> > > exceptionally expensive, though as usual, I still have more to look at.
> >
> > I think we would recommend GIST because it is easier.
>
> Would someone be able to explain to me exactly what GIST is? I thought it
> was just a _type_ of index, but is it actually a generalised index-creating
> framework? Do other DMBSs use it? Is it a cool thing I could talk about
> when I give my talk at UWA tommorrow?
>
> Chris
>
>

In response to

  • GIST at 2002-03-14 02:48:09 from Christopher Kings-Lynne

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 2002-03-19 12:00:36 Re: Time for 7.2.1?
Previous Message Oleg Bartunov 2002-03-19 11:41:31 Re: Bitmap indexes?