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
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 |