Summary
This chapter was all about indexes. We learned about when PostgreSQL will decide on an index and which types of indexes exist. On top of just using indexes, it’s also possible to implement strategies to speed up your applications with custom operators and indexing strategies.
If you want to push its capabilities to the limit, PostgreSQL offers custom access methods.
In Chapter 4, Handling Advanced SQL, we’ll talk about advanced SQL. Many people aren’t aware of what SQL is capable of, so I’m going to show you some efficient, more advanced SQL techniques.
