Why autovacuum is important in PostgreSQL and how to configure it properly.
Vettabase Blog
Read our expert blog with articles on MariaDB, MySQL, PostgreSQL, Cassandra and related tools & technologies.
Code or configuration versioning comes with a potential problem: fixing mistakes can be tricky. Here are some solutions for the most common problems.
The optimal way to store a MD5 hashes in MariaDB, and how to work with them.
Testing backups is often considered too expensive. But it is not, if the tests are adequately designed.
MariaDB supports regular expressions, but regexps won't use indexes. Here's a workaround that can be used in some cases.
Databases and technical debts: here's a list of requirements your database infrastructure should have.
Semantics and use cases of the WITH TIES syntax.
How to remote duplicate values from a table to add a UNIQUE index, in MariaDB.
Vettabase specialises in expert consulting and automation for your database infrastructure. We offer professional services and training for MySQL, MariaDB, PostgreSQL and Cassandra.