LISTEN/NOTIFY performance in PostgreSQL
A NOTIFY in the transaction capped PostgreSQL 18.6 and 19 RC1 at about 3,900 commits per second, with 8 clients or 64. Sending notifications in batches after commit brought 64 clients back to 50,000.
A NOTIFY in the transaction capped PostgreSQL 18.6 and 19 RC1 at about 3,900 commits per second, with 8 clients or 64. Sending notifications in batches after commit brought 64 clients back to 50,000.
29 read-only tools for TeamCity. Paste the link to a failed build, get a root-cause analysis built from the actual log lines and test failures.
The tool description is a big part of the interface. If the model can't tell when to call a tool from its description and schema, quality falls apart.
memfd, PE loaders, unlink-after-dlopen. Three operating systems, three different definitions of 'in memory'.
Encrypt a Python package tree, ship it over the network, load it from memory. What works, what doesn't.
16 tools for searching CDN properties, browsing EdgeWorker code, querying DNS, and inspecting network lists. All read-only.
AI coding agents compressed the feedback loop from hours to seconds. That compression has a name.
Can an AI assistant connected through MCP change your data? Only through the tools the server exposes. Where read-only is enforced, from token scopes to tool annotations, and why I build only read-only servers.
Python, Rust, Go, TypeScript, C#. When does the language actually matter?
MCP servers can cache, pre-aggregate, and transform data independently of upstream services.
The model provides the reasoning. Everything around it determines whether it works once or every day.