Advertisement
Published in:
2021 | OriginalPaper | Chapter
5. Short Queries and Indexes
Authors : Henrietta Dombrovskaya, Boris Novikov, Anna Bailliekova
Published in: PostgreSQL Query Optimization
Publisher: Apress
Activate our intelligent search to find suitable subject content or patents.
Select sections of text to find matching patents with Artificial Intelligence. powered by
Select sections of text to find additional relevant content using AI-assisted search. powered by
Abstract
This chapter introduces and elaborates the concept of a short query. A query is short if it requires only small tables or a small fraction of rows in a large table to produce the output. Several examples presented in this chapter illustrate how to identify and predict performance problems, how to choose the most appropriate indexes, and how to support access to skewed data with partial indexes available in PostgreSQL.