PostgreSQL performance on Linux is often discussed in terms of SQL tuning, indexes, and query plans. Yet many real-world performance problems originate much lower in the stack: inside the Linux page cache and its writeback policy. PostgreSQL deliberately relies on the kernel for file caching and writeback, which means that kernel misconfiguration can silently undermine …
For several years of my professional life, I’ve lived between worlds – Linux for development, Windows for daily comfort and gaming, and macOS when the polish and ecosystem just made things feel… nice. But I’ve always felt like I was cheating on one platform with another. No single environment ever gave me the full stack …
After years of using macOS, I recently decided to install Linux on my old (unused) 13-inch MacBook Pro from 2019 – the one with the infamous Touch Bar and Apple’s T2 security chip. It wasn’t just an experiment. I wanted a fully working x64 based Linux desktop without buying any new hardware, and therefore I …
Switching My 2019 MacBook Pro to Linux: The T2-Ubuntu Journey + read more
In this comprehensive technical walkthrough, I’ll take you through a real-world journey of troubleshooting and tuning a high-performance 40 Gbit Ethernet setup using Intel XL710 network cards connected through a Cisco Nexus 3064 switch. The goal was simple but challenging: to achieve near line-rate performance using iperf3 between two Linux (Proxmox) systems. When I first started testing …
Maximizing 40G NIC Performance on Linux with Intel XL710 and Cisco Nexus Switches + read more
As you know, I’m a crazy person, and I have done a lot of different computer science research projects like developing my own RISC-based CPU and implementing my own x64-based operating system. But over the last weeks and months, I have spent a lot of time doing some low-level research in the Linux Kernel. This work …
vscode-binutils: Analyzing Binary Files directly within Visual Studio Code + read more
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
