In this chapter, you've learned how to use advanced features available in the Heroku Postgres platform.

These features allow you to increase the power of your database by installing extensions that add functionalities to work with data types, indexes, functions, statistics, languages, and full-text searching in your Postgres database.

You have also understood how the Heroku Postgres cache system works. It is also possible to achieve a 99.99% of data caching if your application database and application are well developed.

PostGIS was another interesting feature that you've learned in this chapter. Through this, you are able to work with geographic objects in your SQL queries. You've also noted that PostGIS is available in beta mode on Heroku Postgres.

Finally, you've understood how the tuning process works in your database. You've seen that, from time to time, useless lines are generated. In the vast majority of cases, you don't need to worry about cleaning these lines, because Heroku...