Hi list,
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