In this chapter, you learned how to detect basic performance bottlenecks. In addition to this, we covered the very basics of the PostgreSQL optimizer and indexes. At the end of the chapter, some important memory parameters were presented.

In the next chapter, we will dig into user management and user permissions; some important aspects related to security will also be discussed.