Today I would like to talk about how to implement materialized views in PostgreSQL, utilizing them in a Ruby on Rails application.
PostgreSQL, known commonly as Postgres, is an multi-platform, open source SQL database system. It is one of the most popular database systems and second-most used open source database in the world. The development for Postgres is being done under the PostgreSQL Global Development Group. If you’ve never used Postgres I’d recommend trying it on your next project, it’s really cool.
The tutorial is split into three parts as follows:
- What is a Database View.
- What is a Materialized View.
- How to add a Materialized View to a Rails application.
Continue reading %Speed up with Materialized Views on PostgreSQL and Rails%