Modifying table structures is sometimes necessary, or desirable. Modifying them online can be a pain, especially with big tables. Migrations should be ran properly in production.
hstore is a PostgreSQL extension that allows to store key/value pairs in relational tables and work with them.
Let’s use Percona User Statistics to analyse our most used tables, and to look for problems where they mostly matter.