robins.in

Maintaining a home lab with a diverse fleet of servers is a constant balancing act, but the real challenge is finding a way to pool mismatched, leftover drives across separate machines without turning storage administration into a second full-time job.

Sometimes the most entertaining way to test a new orchestration tool isn't to run a standard benchmark, but to lock two state-of-the-art AI models in a virtual room and make them debate historical facts.

This is an opening post (of a series) about my attempt at automatic B-tree index compaction integrated into autovacuum.

In distributed database environments, balancing durability and performance is a constant tug-of-war.

Cloud AI is incredibly convenient, but the costs scale rapidly once you start leaning on long-context workflows.

It's that time again.

Finally - an update to the AI workbench, and one hell of an update it is :) !

Understanding Google AI Credits: What You're Actually Paying For If you've subscribed to Google AI Pro [1] (or are eyeing an upgrade), you've probably noticed the word "credits" appearing everywhere — in your billing dashboard, in the Gemini app, and insi…

Technical Features Surfing niche streaming sites without inline film ratings is a recipe for endless tab-opening and "analysis paralysis."

PostgreSQL 18 introduces native "Skip Scan" for multicolumn B-tree indexes, a major optimizer enhancement.

Unless you've built a massive real-time notification system with thousands of distinct channels, it is easy to miss the quadratic performance bottleneck that Postgres used to have in its notification queue.

If you've ever had to scrub significantly large tables—whether updating older records or deleting expired ones—you know the pain of trying to do it efficiently without locking the entire table.

The hidden cost of knowing too much.

The Postgres planner just got a new superpower: X-ray vision for your black-box functions.

A recent commit to the PostgreSQL master branch brings a nice quality-of-life optimization for a very common SQL pattern - improving performance by up to 64% for SELECT COUNT(h) where h is a NOT NULL column.

The PostgreSQL Buildfarm is a global network of machines that continuously test PostgreSQL across a wide range of operating systems, architectures, compilers, and branches.

Curiosity often leads to the most interesting technical adventures.

After my positive first impressions with Pi-hole, I decided to take the next logical step: eliminating my dependence on external DNS resolvers entirely.

(This is first of a 2 part series, where I explore pi-hole as a DNS caching solution-Here's Part 2) I've had a Raspberry Pi 4 sitting idle for months, and finally decided to put it to good use by setting up Pi-hole for network-wide DNS caching and ad bloc…

Performance bottlenecks in Postgres logical replication or Change Data Capture (CDC) stream can be subtle, but one specific wait event, ReorderBufferWrite, often points directly at how your application interacts with the database during these processes.

FOR KEY SHARE optimization and the SLRU Trap Optimizing database concurrency is a constant balancing act.

How much storage does an empty table in Postgres take?

In continuation of the recent posts...

Trying out Ollama - Your 10 year old box would do too.

I am just starting my AI journey, and trying to get Ollama to work on my linux box, was an interesting non-AI experience.