In the previous chapters, you've learned the main concepts about Heroku Postgres, which usually cover most of the functions that you will need.
You have reached the last chapter and this is a very special chapter because it covers a collection of advanced features that I preferred to cover just in one chapter as an excellent reference for you.
In this chapter, you will learn about the main extensions of the Postgres database, and understand how to enable PostGIS to work with spatial data, text search tools, and data cache. You will also gauge how you can perform optimizations and performance analysis in your database.
This chapter covers the following topics:
Heroku Postgres extensions
Full text search dictionaries
Data caching
Setting up PostGIS
Database tuning
Performance analysis