Re: obsolete indexing method "rtree"

From: Jürgen Purtz <juergen(at)purtz(dot)de>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: obsolete indexing method "rtree"
Date: 2020-08-06 07:18:35
Message-ID: e1a6fe18-b4f1-3d4e-8788-ced8c08e086a@purtz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs


> Why?

Because it can hinder the learning process. And it's possible that
people ignore or forget about the warning message, but are confused
somewhat later that commands like \d shows GiST instead of RTREE.

> It's not hurting anything to continue the substitution in CREATE
> INDEX.
Yes, it's not hurting. But it makes the life of newcomers a little
harder. Why not stripping away thinks which aren't used since 12 years?
> 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.
This comment is not specific to the old rtree implementation. In
general, the input to R-Trees and the algorithm which creates the
'rectangles' in non-leaf nodes influences the building of the tree and
hereinafter the performance of access methods.
> Perhaps it's talking about a deficiency
> that was specific to the old rtree code.

And sometimes even experts have to spend time thinking about the situation.

Nevertheless, this is a tiny issue. Unfortunately I don't have the
knowledge to modify the C-source and create a patch.

--

Jürgen Purtz

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2020-08-06 08:12:13 Re: obsolete indexing method "rtree"
Previous Message David G. Johnston 2020-08-06 06:29:31 Re: Typo in the Section "3.6. Inheritance"