When and Why PostgreSQL Indexes Are Ignored

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

While it's true the most problems can be solved by the appropriate use of the index, there are cases where you will just waste resources doing so. For casual developer it might seems like PostgreSQL decided to do its own thing, but when you look behind the scenes it all makes perfect sense. Here's a quick run down of the some reasons why planner might pass on index and rather do things…

Read on boringsql.com ↗