This chapter covered the important aspects of PostgreSQL indexing. The focus was on common queries causing common indexing-related problems faced by many people. Some aspects of full-text searching were covered as well.

In the next chapter, you will learn how to read data efficiently.