Database management

Cześć polska! SQLDay2024 in Wrocław

Welcome to the SQLDay!! With these words, the start of the event was announced punctually at 10 am. Now the question, what can we expect? A total of 59 speakers in 49 sessions will share their(…)

MariaDB – Repair Replication Through DB Restore (mysqldump)

Introduction Maintaining database replication integrity is paramount for businesses relying on databases. Replication ensures that changes made on the master database are reliably propagated to replica databases, guaranteeing data consistency and availability across the system. In this comprehensive guide,(…)

Attending SQLDay 2024 in Wrocław, Poland

Here’s a short post about a conference I’m attending right now. SQLDay is one of the biggest events in Europe dedicated to the Microsoft data platform, including databases, Big Data and Business Intelligence solutions, and advanced data(…)

A first look at openSUSE Leap Micro 6.0

Recently the openSUSE project announced the Alpha release of Leap Micro 6.0. This version of the openSUSE operating system is optimized for container workloads and edge computing. One of the cool(…)

Another file system for Linux: bcachefs (3) – Mirroring/Replicas

This is the third post in this little series about bcachefs. The first post was all about the basics while the second post introduced bcachefs over multiple(…)

Another file system for Linux: bcachefs (2) – multi device file systems

In the last post, we’ve looked at the very basics when it comes to bcachefs, a new file system which was added to the Linux kernel starting from version 6.7. While we’ve already seen how(…)

Another file system for Linux: bcachefs (1) – basics

When Linux 6.7 (already end of life) was released some time ago another file system made it into the kernel: bcachefs. This is another copy on write(…)

PostgreSQL 17: pg_buffercache_evict()

In PostgreSQL up to version 16, there is no way to evict the buffer cache except by restarting the instance. In Oracle you can do that since ages with “alter system flush buffer cache“, but(…)

PostgreSQL 17: Split and Merge partitions

Since declarative partitioning was introduced in PostgreSQL 10 there have been several additions and enhancements throughout the PostgreSQL releases. PostgreSQL 17, expected to be released around September/October this year, is no exception to that and will come with(…)

PostgreSQL 17: Add allow_alter_system GUC

Some time ago I’ve written about the options to disable the “alter system” command in PostgreSQL. While there is nothing up to PostgreSQL 16 to do this natively, there are solutions for this requirement (see(…)