Topic - Edition
An Amazon Aurora MySQL cluster can exhaust its virtual index ID limit, after which any CREATE INDEX that includes a virtual column fails with error 63955 until you rebuild the databases. This post shows how to recognize…
RDS Proxy multiplexes many client connections across a small pool of database connections, but connection pinning, pool fragmentation, and uncommitted transactions can silently disable that benefit for PostgreSQL…
Metrics alone can't always pinpoint what is reducing RDS Proxy multiplexing for PostgreSQL. Part 2 shows how to use Amazon CloudWatch Logs Insights with enhanced proxy logs to find the root cause, what healthy…
I'm getting ready to deploy a small Axum web service for a client in Canada, and it stores customer details. PIPEDA covers most private businesses here, and BC public bodies and Quebec's Law 25 add stricter rules about…
Aurora PostgreSQL now supports express configuration in AWS CloudFormation for infrastructure as code deployment. This launch enables you to automate the infrastructure deployment of your Aurora clusters through…
Ask an underwriter to describe a policy, and you’ll get a coherent answer: A contract, for a customer, covering a car or a house, with a handful of coverages, each with a limit and a deductible, plus a history of every…
Just a short & quick follow-up to [yesterdays blog] before I run out the door. I hadn’t been paying attention, and yesterday’s postgres release had a few surprises for me. I’m catching up now. First: read [Devrim’s…
New features PGXSExtension module — a single config-driven module for testing out-of-tree PGXS extensions, keyed by a pgxs_extensions hash in the config (one entry per extension). New test extensions no longer need…
Security updates have been issued by AlmaLinux (.NET 10.0, .NET 8.0, .NET 9.0, firefox, gcc, grafana, grafana-pcp, gstreamer1, gstreamer1-plugins-base, java-1.8.0-openjdk, kernel, kernel-rt, libimobiledevice,…
PostgreSQL’s November minor releases patch 52 CVEs and 140+ bugs across all supported branches and retire PostgreSQL 14. Notes on what continuous AI code auditing is doing to 30-year-old C codebases, the post-upgrade…
