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 1k3Jz7-0003AA-00 for pgsql-docs@arkaria.postgresql.org; Wed, 05 Aug 2020 14:01:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k3Jz3-0000Df-SI for pgsql-docs@arkaria.postgresql.org; Wed, 05 Aug 2020 14:01:33 +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 1k3Jz3-0000DQ-Mn for pgsql-docs@lists.postgresql.org; Wed, 05 Aug 2020 14:01:33 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k3Jz1-0003t2-3Y for pgsql-docs@lists.postgresql.org; Wed, 05 Aug 2020 14:01:33 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 075E1SOH2510905; Wed, 5 Aug 2020 10:01:28 -0400 From: Tom Lane To: =?UTF-8?Q?J=c3=bcrgen_Purtz?= cc: Pg Docs Subject: Re: obsolete indexing method "rtree" In-reply-to: <9cda4603-76d0-b063-5dc3-a9a99506340b@purtz.de> References: <9cda4603-76d0-b063-5dc3-a9a99506340b@purtz.de> Comments: In-reply-to =?UTF-8?Q?J=c3=bcrgen_Purtz?= message dated "Wed, 05 Aug 2020 13:30:39 +0200" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <2510903.1596636088.1@sss.pgh.pa.us> Content-Transfer-Encoding: 8bit Date: Wed, 05 Aug 2020 10:01:28 -0400 Message-ID: <2510904.1596636088@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk =?UTF-8?Q?J=c3=bcrgen_Purtz?= writes: > 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? Why? It's not hurting anything to continue the substitution in CREATE INDEX. The example in comments.sgml is just an example, and is not meant to reflect a built-in object any more than the adjacent examples are. Possibly the comment in seg.sgml should be adjusted to refer to GiST indexes --- but then again, it's not entirely clear whether it's even still relevant for GiST indexes. Perhaps it's talking about a deficiency that was specific to the old rtree code. regards, tom lane