PostgreSQL Making use of Index-Only Scans and Covering Indexes 07/12

Опубликовано: 05 Ноябрь 2024
на канале: High-Performance Programming

6,023

If you found this video helpful, you could check the full course on Udemy. In this course, you’ll find tips for tuning PostgreSQL 12 like a pro.

Use the link below to get a 60% OFF.

PostgreSQL High-Performance Tuning Guide - Full Course
https://www.udemy.com/course/postgres...

There is no need to go to the table in most cases if all the data can already be taken out of the index. Going to the table is (almost) only required if additional fields are queried. Therefore, the index-only scan will promise significantly better performance than a normal index scan.
Furthermore, it can even make sense to include an additional column into an index to enjoy the benefit of this feature. This is also known as covering indexes.