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.
Read morePostgreSQL hstore: key/value in relational tables
hstore is a PostgreSQL extension that allows to store key/value pairs in relational tables and work with them.
Read moreUnderstanding tables usage with User Statistics (Percona Server, MariaDB)
Let’s use Percona User Statistics to analyse our most used tables, and to look for problems where they mostly matter.
Read more