Tuning PostgreSQL Auto-vacuum

Why autovacuum is important in PostgreSQL and how to configure it properly. Continue reading Tuning PostgreSQL Auto-vacuum
Expert consulting and automation for your database infrastructure
Why autovacuum is important in PostgreSQL and how to configure it properly. Continue reading Tuning PostgreSQL Auto-vacuum
Code or configuration versioning comes with a potential problem: fixing mistakes can be tricky. Here are some solutions for the most common problems. Continue reading How to fix git mistakes
The optimal way to store a MD5 hashes in MariaDB, and how to work with them. Continue reading MariaDB/MySQL: Working with MD5 or other hashes
Testing backups is often considered too expensive. But it is not, if the tests are adequately designed. Continue reading How to test database backups
MariaDB supports regular expressions, but regexps won’t use indexes. Here’s a workaround that can be used in some cases. Continue reading MariaDB: The regexp + LIKE optimisation
Databases and technical debts: here’s a list of requirements your database infrastructure should have. Continue reading A checklist for Database backup automation
Semantics and use cases of the WITH TIES syntax. Continue reading MariaDB: WITH TIES syntax
How to remote duplicate values from a table to add a UNIQUE index, in MariaDB. Continue reading How to delete duplicate rows in MariaDB
Periodical maintenance windows can be healthy both for your team and your infrastructure. Business won’t be damaged. Continue reading The importance of maintenance windows
Before introducing a new database technology in your organisation, consider the drawbacks. Continue reading The costs of using multiple database technologies