Database Administration & Monitoring, Database management, Operating systems FreeBSD basics – 5 – Providing services using Jails 05.12.2024 by Daniel Westermann This post builds on top of the previous post in which we’ve created a simple thin Jail. The goal of this post is, to put a bit of automation around this and to provide a simple(…)
Operating systems FreeBSD basics – 4 – Jails 03.12.2024 by Daniel Westermann Now that we know how to get started with FreeBSD, how to manage users and groups, and how to work with services, we’ll look a bit into(…)
Operating systems FreeBSD basics – 3 – Services 29.11.2024 by Daniel Westermann This is the third post in the series about getting started with FreeBSD. We’ve looked at the first steps here, and users and groups here. Today we’re looking at how FreeBSD handles(…)
Operating systems FreeBSD basics – 2 – Users & Groups 28.11.2024 by Daniel Westermann In the last post, we’ve initially configured FreeBSD so that networking is up and running, additional packages can be installed, and the system was patched to the latest release. In this post we’ll look at how(…)
Operating systems FreeBSD basics – 1 – The first steps 27.11.2024 by Daniel Westermann In case you follow the blogs here, you might have noticed that I got interested in FreeBSD over the last months (or even year(s)). The reasons for this are multiple: FreeBSD development is organized in very(…)
Database Administration & Monitoring, Database management PostgreSQL: Maybe we should give ZFS a chance (3) – testing with an aligned record size 26.11.2024 by Daniel Westermann In the last post about PostgreSQL on ZFS the pgbench tests showed, that ZFS was slower for the standard tests compared to ext4 on Debian. A comment to that post made me wonder if changing the ZFS record size(…)
Database Administration & Monitoring, Database management PostgreSQL: Maybe we should give ZFS a chance (2) – testing 13.11.2024 by Daniel Westermann In the last post we’ve set the baseline for comparing ext4 to zfs when it comes to PostgreSQL. We’ve ended with two PostgreSQL clusters, one running on the ext4 file system while the other is running(…)
Database Administration & Monitoring, Database management PostgreSQL: Maybe we should give ZFS a chance (1) – baseline 10.11.2024 by Daniel Westermann Recently I’ve switched my PostgreSQL playground from Linux to FreeBSD. Not because I don’t like Linux anymore, just because I like trying out other operating systems and see what works the same and what is different.
Database Administration & Monitoring, Database management PostgreSQL: Partitioning an existing table (almost) online using table inheritance 01.11.2024 by Daniel Westermann The PostgreSQL mailing list archives are a wonderful place to get new ideas just by reading through random posts. This time I found an interesting idea on how to partition an existing(…)
Database Administration & Monitoring, Database management PostgreSQL: Delaying authentication to debug a process 31.10.2024 by Daniel Westermann While investigating a customer issue (details here) one of the replies suggested to use pre_auth_delay to add a delay before a session is authenticated. Even if this was not useful for the actual issue, this(…)