News for hackers. Stuff that matters.

A comment on How Postgres chooses which index to use for a query. Parent comment

Re:How Postgres chooses which index to use for a query by Blackthorn on Friday April 22, 2022 @01:50AM (#31118621)
That would be a huge compatibility nightmare any time you upgraded database versions.
[ Parent | on HN ]
Re:How Postgres chooses which index to use for a query by branko_d on Friday April 22, 2022 @02:07AM (#31118722)
Not really. The basic concepts of "tables/indexes" and "access paths" has been stable for years (decades really). So if you wrote something like: MY_TABLE.MY_INDEX.SEEK(whatever), that would have the same meaning as it did 30-40 years ago. Same for range scans, nested loop / merge / hash joins, sorting etc.
[ Parent | on HN ]