Database management

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 features(…)

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 devices.

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 easy(…)

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 file(…)

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 not(…)

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 two(…)

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 linked(…)

Clone Oracle Database configured with Oracle Key Vault (OKV)

How to clone an Oracle Database which is configured to store the TDE (encryption keys) in the Oracle Key Vault (OKV)(…)

PostgreSQL 17: Convert a physical replica to a logical replica using pg_createsubscriber

Logical replication in PostgreSQL came with Version 10, which is already out of support. I’ve written about this a long time ago but the basic building blocks are still the same. Setting(…)

Getting started with Greenplum – 6 – Why Greenplum?

Now that we have the basic knowledge for operating a Greenplum cluster we should talk about why Greenplum can be option and what are the benefits of such a system. Again, here are the previous posts:(…)