Full text search dictionaries are a mechanism that allows the identification of documents in natural language corresponding to a query and optionally sorts them by relevance. In the upcoming sections, you will use two of these extensions.
This is a full-text search dictionary extension used for indexing integers (signed and unsigned), preventing the growth of the unique word number, which greatly affects the search performance.
$ heroku pg:psql --app your-app-name CREATE EXTENSION dict_int;
For more details, visit the documentation at http://www.postgresql.org/docs/current/static/dict-int.html.
Basically, this consists of a text searching and filtering dictionary, which means that its output is always passed to the next dictionary, which is different from the normal behavior of dictionaries. This extension removes accents from lexemes. It is the minimum unit of distinctive semantic system of a language.
$ heroku pg:psql --app your-app-name CREATE...