These days there’s been a lot of talk about Postgres having an impact on “everything”. Whether it’s replacing legacy systems, creating a new greenfield project or even implementing it as a back-end to an agentic AI, Postgres is today’s poster child for innovation. So performing something as dull and straightforward as a database migration should … Continued
The post Migrating Postgres: Solving A Puzzle That Shouldn’t Be Hard appeared first on Percona.
A recent case in our Percona Support team started with a familiar complaint. A PostgreSQL standby lagging behind its primary. Although the problem was simple, it brought a specific flavor that’s worth sharing. The customer had already reached out to AWS Support about the storage layer behind the database, an Amazon FSx filesystem mounted over … Continued
The post Replication Lag on AWS FSx: The Hidden EC2 Single-Flow Bandwidth Limit appeared first on Percona.
Introduction A software bill of materials (SBOM) offers end users enhanced supply chain visibility, thereby facilitating license compliance and timely vulnerability detection. An SBOM of an application, library, or framework (collectively referred to as a “component”) is a machine-readable document that enumerates all other components it incorporates, including transitive ones. In this way, an SBOM … Continued
The post Software Bill of Materials in Percona Server for MongoDB appeared first on Percona.
I am a distributed systems researcher. I mostly read and write about distributed systems and lightweight formal methods. But as my blog definition says, the blog is about "distributed systems broadly defined and other curiosities".
The last two years, LLMs were unavoidably the biggest part of those curiosities. However, I was still surprised how much I had written about them, when I went looking for a line I remembered coining. Something like, "LLMs are good at mediocrity, but really fast".
I couldn't find the line, but instead I found a pile of my takes on LLMs scattered across the blog, and I figured it was worth collecting them into an index. So here it is, enjoy! I also threw in my overall take on LLMs that has stayed constant through their four years of reign so far.
Our Collective Bike Shed Moment (June 26)
Are We Becoming Architects or Butlers to LLMs? (Feb 26)
How LLMs may affect academic writing (Feb 26)
Agentic AI and The Mythical Agent-Month (Jan 26)
The Agentic Self: Parallels Between AI and Self-Improvement (Jan 26)
Too Close to Our Own Image? (Jan 26)
Rethinking the University in the Age of AI (Jan 26)
Welcome to Town Al-Gasr (Jan 26)
The Invisible Curriculum of Research (Oct 25) — mostly about AI, trust me
Academic chat: On PhD (Oct 25) — follow-up to the above
What I'd do as a College Freshman in 2025 (Apr 25)
Hot damn, 11 posts deep... Apparently I am an AI thought leader now by accident.
Looking at the dates, I was clearly most obsessed with LLMs in January 2026. There is no surprise there, since agentic tools and models turned a real corner that Thanksgiving of 2025.
What has stayed constant over the years, however, even as the models themselves got much better, is my verdict on them. The phrase I had been hunting for turned out to be: "LLMs excel at high-throughput mediocrity".
LLM output looks excellent when you are not the expert in the room. But on a topic you actually know, you would evaluate the output only as a notch above mediocre. This is the Gell-Mann amnesia effect in action. However, the difference is that LLMs can produce this output fast, and they never get tired.
That is actually very handy when you don't want to work on a part of a project that requires mediocre effort. And the best thing is, you don't have to get bogged down doing it, and keep your momentum going as the LLMs handle those parts. They are a gift from the Gods if you have ADHD. The mundane half of a project that used to stall me out completely is no longer an obstacle.
Which is all to say, LLMs are a tool. Use the right tool for the right job and you'll love it. Master your tools, and don't focus on their shortcomings for everything and all things.
Even with all these tools running, my highest-ROI tool is still just Emacs (going strong against LLMs at 50 years old, like me), where the actual thinking, writing, and planning happens. Use LLMs for the uninteresting stuff, where mediocrity is sufficient, so you have your time and energy for the work that actually matters.
Well, LLMs didn't just show up as a curiosity in my work, they also collided more directly with my research. Here as they show up in my paper reviews, workshop write-ups, and conference notes, where formal methods and AI actually crossed paths.
Specula: Scaling formal specifications for autonomous model checking of system code (August 26)
Our MongoDB TLA+ Workshop (June 26)
Writing Code vs. Shipping Code: Productivity Effects Across Generations of AI Coding Tools (June 26)
ACM CAIS: Conference on AI and Agentic Systems (June 26)
BugBash'26 Keynote: We won, what now? (April 26)
Measuring Agents in Production (March 26)
Measuring AI Ability to Complete Long Software Tasks (March 26)
SysMoBench: Evaluating AI on Formally Modeling Complex Real-World Systems (March 26)
Beat Paxos (March 26)
Barbarians at the Gate: How AI is Upending Systems Research (Oct 25)
Supporting our AI overlords: Redesigning data systems to be Agent-first (Sep 25)
Neurosymbolic AI: Why, What, and How (Aug 25)
This is an external post of mine. Click here if you are not redirected.
Date of release: 19 August 2026 Severity: High Affected product: PMM Impacted versions: 3.9.0 and below Summary Percona has recently been made aware of a security vulnerability affecting PMM. We take the security of our products and the protection of our customers’ data with the utmost seriousness. This advisory describes the vulnerability, the immediate steps … Continued
The post Security Advisory: Privileged ClickHouse access through the Grafana data source in PMM appeared first on Percona.
The common practice is to size the Galera Cache based on write volume measured during peak load, but often it is more of a guesswork. The writeset cache capacity planning is crucial to shorten the maintenance time and avoid long state transfers while the cluster runs with reduced compute power. Now, if you could understand … Continued
The post Stop guessing at gcache: inspect Galera/PXC write sets with gcache-inspector appeared first on Percona.