From: Elena Camossi <elena.camossi@gmail.com>
To: pgsql-sql@postgresql.org
Subject: GiST index implementation
Date: Thu, 2 Aug 2007 16:02:19 +0200
Message-ID: <5dea05d0708020702o2a2f66fan69d6c0e2e60a3f26@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: elena.camossi@gmail.com
Subject: Re: GiST index implementation
In-Reply-To: <5dea05d0708020702o2a2f66fan69d6c0e2e60a3f26@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox