News for hackers. Stuff that matters.

A comment on PostgreSQL Indexes: First principles. Parent comment

Re:PostgreSQL Indexes: First principles by timtadh on Friday February 26, 2016 @04:29PM (#11184396)
Most databases do have a way to force the index. See for example the MySQL way of doing it: https://dev.mysql.com/doc/refman/5.5/en/index-hints.html . You probably already know this but I mention it in case someone else does not.
[ Parent | on HN ]
Re:PostgreSQL Indexes: First principles by kbenson on Friday February 26, 2016 @04:37PM (#11184450)
Does that actually fail on an index missing? The docs for FORCE INDEX say "a table scan is used only if there is no way to use one of the named indexes to find rows in the table", which to me implies it's more like FORCEFULLY SUGGEST.
[ Parent | on HN ]
Re:PostgreSQL Indexes: First principles by meritt on Friday February 26, 2016 @04:48PM (#11184546)
If your force index names a non-existent index, you'll get an error.
[ Parent | on HN ]