Database Reference
In-Depth Information
Summary
In this chapter, you've learned how to use advanced features available in the Heroku Post-
gres 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 Postgres does it automatically for
you; but, if necessary, you can perform VACUUM manually.
You have reached the end of this topic and I hope your learning journey about Heroku Post-
gres has been very fruitful and that you have acquired all necessary knowledge to improve
your work routine in this amazing platform built by Heroku. It was a great honor to help
you in this learning process and I hope to see you in future topics.
I say goodbye to you with a message from the great
Leonardo da Vinci
:
"A little knowledge puffs up; great knowledge makes humble. Blasted ears raise proud
heads; those full of grain bow down."