Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k3HdE-0005o8-Jb for pgsql-docs@arkaria.postgresql.org; Wed, 05 Aug 2020 11:30:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k3HdD-0007AZ-1g for pgsql-docs@arkaria.postgresql.org; Wed, 05 Aug 2020 11:30:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k3HdC-0007AS-Rf for pgsql-docs@lists.postgresql.org; Wed, 05 Aug 2020 11:30:50 +0000 Received: from mout.kundenserver.de ([217.72.192.75]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k3Hd8-0002Uh-6p for pgsql-docs@lists.postgresql.org; Wed, 05 Aug 2020 11:30:50 +0000 Received: from [192.168.178.43] ([77.189.57.155]) by mrelayeu.kundenserver.de (mreue109 [212.227.15.145]) with ESMTPSA (Nemesis) id 1M2fDl-1k1uJx3aEp-0049sO for ; Wed, 05 Aug 2020 13:30:42 +0200 From: =?UTF-8?Q?J=c3=bcrgen_Purtz?= Subject: obsolete indexing method "rtree" To: Pg Docs Message-ID: <9cda4603-76d0-b063-5dc3-a9a99506340b@purtz.de> Date: Wed, 5 Aug 2020 13:30:39 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="------------3371B03B56C34D04AEA5FFE9" Content-Language: en-US X-Provags-ID: V03:K1:QzAB4Vi6q1IcDqFKz8tTi8d7ZWS4Ckni0fDo7+0DebcKMmXGSGu 6BQ+p3tNlmOt8sxndz3quEiCKA7HPP50DeudZdIVwE4OIzXz0ECwvdfdGu20hmB3gOB18oU meQvog4p7DpwW3CZlk+Uks46wB5DJpwdqeuKtoVryoPaQvcyL60+BtD53exFPM1UjOPZ5Bk Eg/1g3hCF/uyaQGshOjBg== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:+COt7xT9vkI=:q2xssRRO/E9/E7uzb1JS/r m/eY3aeYefl0MbiaKmH2wOZYRtvPfkX3FWsNMAftwvE/ziagM1wnyVW48CZdTCwAHtMzR7F0V P0Gfqr9ZBdtS2S0wVGCgm8cxUJ646eZhof8F+BhXrsHUDcpEp1zVXqf08aWMzMDjGrYqBP0/y IiEuYg0kx/qno5NxucjxVo7PYhgGp5ByxZ+/UDSo7pF6rqJRyFs/TknY1SDivUpEBBEF7lVZC Q3p3H3RfO66wFezY/3vNNhZIIV0pxgclmrN+BBllZgLfdqX1rr9j0QVVrsX+P2UJ5CJ57cjzE NevbEH1fxNsykJLlhoBgileeW92zXjoEGLqDZZVTdQsH6qtKF/xMxUIROPMzYRrrVtHrYgNIG h3BTEWRi6Z8NEAAg96mwiUvk0FB6z3Zf+WDGn2BeBLr+Ttuff49gXw/OFCeLyzqXt6mF5pPv8 T9YJk/VMOakOiUmR5yNgReE+KJZhIImM+XVFelr52P1UmTxBskIdwnF+ttBytBHFNqUsj/Dn5 cw7LdKjdjAYEPI4X5kfxtPSpZLnAT8ehPyJWHBScELwWSwnjtcDkaRgoYg1zf7SX2uuBdpbbh QsGbHsk0yOunB3a3G/waL1tDi6zco5gtGu0pZzM1Gsfcz7R25Be5tak3WxlQnyWPw4fGn4v1W I4SmfXOAy4fxbct9RzCJRIYtYFV0zDqVFLkU6HQ27H6XlzeihdfJkdH/Xis147N8vhOb7ZvZG qwujrNj9U8AFRjE4pOTTnqALP/fclpuEx3ze9X3CQHtFtnmG01Mo3p39zTTRzJl5bDgMVg4Cx 2lWgDk0KI7YKlpcmJtlI4eFXlt3wEB0dGSk3OTQpqX2f8jATC73OltlFHyplUBDjxiNe23/ List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------3371B03B56C34D04AEA5FFE9 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit 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 --------------3371B03B56C34D04AEA5FFE9 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

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


--------------3371B03B56C34D04AEA5FFE9--