Idee e spostamenti che contano per chi progetta, costruisce e gestisce software—una lettura breve per restare al passo col mestiere.
Categoria
Google launched AlloyDB in 2022. They claimed it is fully compatible with PostgreSQL. Can be up to 100 times faster for analytical queries than vanilla Postgres. Four years later, I haven't personally seen it gain significant traction. But…
PostgreSQL's JIT compiler trades upfront compilation time for faster query execution—but it silently does nothing if the LLVM library isn't installed.
Do you like building Postgres extensions? Of course you do! My "Let's Build a Postgres Extension" presentation garnered rave reviews at Postgres Conference 2026 in San Jose and PG Data 2026 in Chicago. But what if you didn't go? Sure the…
Vercel just gave their CLI a new trick: when you install a Marketplace integration from the terminal, it also installs that provider's agent skills. A single command now provisions a Neon database on your Vercel project and hands your…
Our first post showed MySQL 9.7 with one change: mark a table ENGINE=DuckDB and its analytical queries run in DuckDB instead of InnoDB. The question we kept getting after that was about replication. Can you keep a normal InnoDB primary for…
In Part 6 of this special Postgres in Production deep dive series, Ryan Booz asks a question that determines how useful pg_stat_statements can be for you at all: do you have a high cardinality workload? This episode covers what that…
PostgreSQL 18's new io_max_concurrency caps per-process I/O operations in flight.
Introduction The purpose of this blog post is to introduce pg_walviz, a new tool to visualize PostgreSQL WAL segment files. pg_waldump is very useful to display a human-readable rendering of the WAL. However, sometimes we also want to see…
In this newsletter, we cover version 9.5 of Elasticsearch, the latest blogs and videos, and upcoming events.
My previous article talked about the checkpoint happiness hint: You probably should not change the checkpoint_timeout setting from its default of 5 minutes. Checkpoint Followup Questions A good follow-up question was raised: can an HA…
Neon Functions are Node.js 24 compute you deploy onto a Neon branch, in the same region as your Lakebase Postgres database, with DATABASE_URL injected automatically. They're long-running enough that agents can stream for minutes and…
There is no shortage of PostgreSQL operators for Kubernetes. Projects such as CloudNativePG, the Zalando postgres-operator, Crunchy PGO, and StackGres have all helped shape the ecosystem. So why did we build another one? Our answer is…
