Daily edition · Databases
TILens turns technical updates into a focused daily brief: official releases, trusted reporting, and practitioner analysis, deduplicated and organized by topic.
Learn how to build, train, and score a credit risk machine learning model entirely in SQL using Oracle Machine Learning for SQL (OML4SQL) on Amazon RDS for Oracle. The built-in AutoML feature selects the best algorithm…
AWS DMS uses exponential backoff for recoverable errors, and default settings can let a change data capture (CDC) task retry silently for up to 30 minutes before failing. This post shows how to tune four…
Many applications that use Amazon DynamoDB for operational data also need vector similarity search, which until now meant running a separate vector database. DynamoDB now supports native vector search. In this post, we…
Here is a query that shows up in every analytics workload: SELECT count(DISTINCT user_id) FROM events; It looks like the cheapest possible thing: count the distinct users. On a machine with cores to spare you would…
Previously I’ve made the case for running an AI-driven incident-response pipeline entirely inside a Postgres cluster: pgvector for retrieval, EDB Postgres AI Hybrid Manager’s on-board model serving for inference, AI…
Jacob Jackson at ByteofDev built something I can only describe as admirably irresponsible (and something I wish I had thought of first): claudegres, a “PostgreSQL” in which Claude is the entire backend. Not Claude…
Vacuum is not a problem as we can help PostgreSQL avoid it with HOT updates. A HammerDB TPROC-C benchmark shows how tuning fillfactor for tables eliminates vacuum and reduces the bloat growth.
Idle sessions consume connection slots and backend memory—not locks or xmin. Learn when and how to reap them without sabotaging your connection pooler.
#660 — August 5, 2026 Web Version Lots of videos from this year's PGConf.dev are now on YouTube and I've rounded up some highlights at the end of the issue! __ Your editor, Peter Cooper Postgres Weekly COUNT(DISTINCT)…
