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) (→Vettabase)
Let’s use Percona User Statistics to analyse our most used tables, and to look for problems where they mostly matter.
Read more