GiST index implementation

From: "Elena Camossi" <elena(dot)camossi(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: GiST index implementation
Date: 2007-08-02 14:02:19
Message-ID: 5dea05d0708020702o2a2f66fan69d6c0e2e60a3f26@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,

what is the default implementation for GiST index? B-Tree or R-Tree?
That is, if i execute the following SQL command:

CREATE index ON table USING Gist (column)

what is the type of the index that is actually built?

If I specify R-Tree instead, with:

CREATE index ON table USING Rtree (column)

I got this message:

NOTICE: substituting access method "gist" for obsolete method "rtree"

and when I look at the SQL code that created the index in pgAdmin, I found
again

CREATE index ON table USING Gist (column).

How can I specify in SQL one of the two implementations provided (e.g.
R-Tree)?

Thank you for helping.

Regards,
-Elena

Browse pgsql-sql by date

  From Date Subject
Next Message Dani Castaños 2007-08-02 16:18:05 Foreign Key inter databases
Previous Message Luiz K. Matsumura 2007-08-02 01:46:00 Re: Alternative to INTERSECT