Database Reference
In-Depth Information
Chapter 8. Extensions, PostGIS, Full Text
Search Dictionaries, Data Caching, and
Tuning
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 col-
lection of advanced features that I preferred to cover just in one chapter as an excellent ref-
erence for you.
In this chapter, you will learn about the main extensions of the Postgres database, and un-
derstand 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
