Book Image

Learning Heroku Postgres

By : Patrick Rafael de Oliveira Espake
Book Image

Learning Heroku Postgres

By: Patrick Rafael de Oliveira Espake

Overview of this book

Table of Contents (17 chapters)
Learning Heroku Postgres
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Keyword List
Index

Self-test Questions


Answer the following questions as true or false:

  1. Are the extensions functionalities that add new features in your database?

  2. Is the cube extension used to remove accents?

  3. Is the HStore extension useful to work with key value data?

  4. Can you store book numbers (ISBN) in your database through the product numbering extension?

  5. Does the PLV8 extension allow you to fire queries directly from inside your JavaScript code application?

  6. Is the full-text extension useful for text searches across dictionaries?

  7. Is it rarely possible to achieve 99% of data cache in your database on Heroku Postgres?

  8. Does Heroku Postgres support PostGIS?

  9. Should you always run the command VACUUM to improve the performance of your database?

  10. Is Heroku Postgres able to do automatic VACUUM in your database?