news
PostgreSQL 19 Release Date Moved to Nov 19 After AI Review Found Too Many Bugs
Eight to ten features were reverted, Postgres 14 hits EOL a week before GA, and here are the pg_upgrade --check steps to run against 19 RC1 now.
postgresdatabaseai
comparison
pg_vectorsearch vs pgvector HNSW: 42 Hours vs 49 Minutes. Here's the Catch
The query win at 100M vectors on 4x less RAM holds up. The 42-hour build gap is tilted, and the extension is alpha and needs PostgreSQL 18.
postgresaidatabase
debugging
How to Migrate a Production Stack to a New Region Without Downtime
A practical walkthrough of migrating a production stack to a new region without downtime, covering DNS, Postgres logical replication, and cutover.
devopspostgresmigration
debugging
Why your async user-creation endpoint silently produces duplicates
A real-world walkthrough of a TOCTOU race condition in an async user-creation endpoint, with three layered fixes and a prevention checklist.
webdevjavascriptpostgres
tutorial
Stash Gives Your AI Agents a Memory That Actually Persists
Stash is a self-hosted persistent memory layer for AI agents, storing episodes, facts, and working context in Postgres with MCP support.
aipostgresmcp
debugging
pgbackrest Maintenance Has Stopped — How to Plan Your PostgreSQL Backup Migration
pgbackrest is reportedly no longer maintained. Here's how to audit your PostgreSQL backup setup and migrate to alternatives like Barman or WAL-G.
postgresdatabasedevops
debugging
How to Stop Nuking Your Postgres Data When Testing Schema Changes
Learn how copy-on-write database branching solves the pain of testing Postgres schema migrations, with practical workflows and CI/CD integration.
postgresdatabasedevops