pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jürgen Purtz <juergen@purtz.de>
To: Pg Docs <pgsql-docs@lists.postgresql.org>
Subject: obsolete indexing method "rtree"
Date: Wed, 5 Aug 2020 13:30:39 +0200
Message-ID: <9cda4603-76d0-b063-5dc3-a9a99506340b@purtz.de> (raw)

We removed the indexing method "rtree" in version 8.3 and replaced it 
with "gist". Until today there are some "rtree" heritages:

  * "CREATE INDEX ... USING rtree ..." is valid syntax and leads to the
    message "NOTICE:  substituting access method gist for obsolete
    method rtree"
  * The documentation refers to the method in ref/comments.sgml and
    ref/create_index.sgml.
  * The documentation uses the term "R-Tree" in gist.sgml, seg.sgml, and
    xindex.sgml. That's ok because in this cases it refers to the
    abstract concept of R-trees and not to the eliminated implementation.

Isn't it time to disallow this syntax and remove all references and 
messages? The situation concerning index types, access methods, operator 
classes, and index related extensions is complicate enough and hard to 
explain to newcomers. Every simplification should be welcomed.

--

Jürgen Purtz

view thread (7+ messages)  latest in thread

Message-ID: <9cda4603-76d0-b063-5dc3-a9a99506340b@purtz.de>
Permalink:  ../9cda4603-76d0-b063-5dc3-a9a99506340b@purtz.de/
Also on:    postgresql.org/message-id/9cda4603-76d0-b063-5dc3-a9a99506340b@purtz.de

 · 

reply

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-docs@postgresql.org
  Cc: juergen@purtz.de, pgsql-docs@lists.postgresql.org
  Subject: Re: obsolete indexing method "rtree"
  In-Reply-To: <9cda4603-76d0-b063-5dc3-a9a99506340b@purtz.de>

* 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