Big release from Jimmy Angelakos: pg_statviz 1.0 is out, and it ships with optional AI-powered analysis. 🐘 pg_statviz is a minimalist extension for time-series analysis and visualization of PostgreSQL internal statistics. With the new --ai flag, each chart gets a [HEALTHY] / [WARNING] / [CRITICAL] verdict and concrete remediation advice from a vision-capable LLM. What's notable about the release: 🧠 Three LLM providers: Anthropic Claude (default), Google Gemini, or local Ollama for air-gapped setups 🛡️ Deterministic rules run before the LLM call, with a severity floor that prevents the model from downgrading real problems 📐 Configuration-aware prompts use your actual pg_settings, plus a calibration block that debunks common Postgres myths (25% of RAM for shared_buffers, default random_page_cost=4, naive work_mem math) 🔒 Prompt-injection containment: user-derived data is wrapped in envelopes so the model treats it as data, not instructions ✋ Fully optional. pg_statviz works exactly as before if you don't pass --ai Jimmy's full announcement: 📖 hubs.la/Q04gBQWr0 Find the extension on GitHub: ⭐ hubs.la/Q04gBQDC0 #postgres #postgresql #dba #monitoring #observability #aiengineering #extensions #opensource #postgresprofessionals

PGDay UK 2026 CFP closes Tuesday, May 12 at 23:59:59 London time. One day left if you've been sitting on a Postgres talk idea. 🗓️ Conference: September 8, 2026, in London 🎤 45-minute sessions Q&A, English only ✅ Selected speakers get free entry (notified before May 29) 🌍 Topics open: scaling, internals, replication/HA, performance, AI on Postgres, DevOps, migrations, case studies, anything Postgres-related Two of pgEdge's own are helping run it: Jimmy Angelakos on the Code of Conduct team and Dave Page on the organising team, alongside Devrim GÜNDÜZ and Chris Ellis. If last week's PostgresEDI lightning talks sparked an idea, this is your chance to expand it into a full session. 📝 Submit your talk: hubs.la/Q04g50jw0 ℹ️ Full CFP details: hubs.la/Q04g505r0 #postgresql #postgres #pgdayuk #conference #cfp #postgresprofessionals #london

The pgEdge Control Plane just shipped two features that go in opposite directions on purpose. 🧩 Supporting Services (fully available): your database and the services around it (MCP Server, RAG Server, PostgREST) now live in the same declarative spec. One JSON, one POST, and the Control Plane provisions everything together with scoped, auto-rotated credentials per service. Co-locate them with database nodes for low latency, or split them onto dedicated hosts. 🐧 systemd Support (Preview): the Docker Swarm requirement that was blocking regulated-industry teams is gone. Run the Control Plane and Postgres as systemd units on standard OS paths. Same declarative API as the container path. RHEL beta is live, Debian to follow. What ties them together: the API doesn't change. Same spec creates a multi-master Spock cluster on Docker Swarm or directly on the host via systemd. Same spec adds an MCP server next to a primary or PostgREST instances at every node. Your CI/CD doesn't care which orchestrator runs underneath. Antony Pegg's full write-up has the JSON example with more details: 📖 hubs.la/Q04f-FJ40 #postgres #postgresql #devops #systemd #databases #opensource #infrastructure #postgresprofessionals #linux #programming #docker

🔥New blog: Semantic caching in PostgreSQL with pg_semantic_cache — meaning-based caching that cuts LLM calls and boosts performance. 🚀 Learn how to set it up & see it in action 👇 hubs.la/Q044CNt20 #Postgres #AI #SemanticCaching #pgEdge #PostgreSQL #SemanticCaching #AI #LLMs #pgEdge #OpenSource #PostgresProfessionals #PostgreSQLDBA

New possibilities! Eliminate issues with fully distributed PostgreSQL from pgEdge. Cloud and on-premises options. Believe it's possible. Learn more. Get a demo. hubs.la/Q02Shw2r0 #pgedge #postgresql #postgresprofessionals #postgresqldba #multimaster

Watch this live presentation given by Postgres expert, Ibrar Ahmed to get a good understanding of MMR. View it now! hubs.la/Q02CNXRS0 #pgedge #postgresql #postgresprofessionals #multimaster #mmr

One hour of downtime will cost your company time, money, and customers. Avoid the risk. Turn to pgEdge. hubs.la/Q02zY9Kl0 #pgedge #postgresql #postgresprofessionals #postgresqldba

Check out PostgreSQL expert, Hari Kiran's blog as he goes through the risks of not having a multi-region PostgreSQL cluster. Lear more and read it today: hubs.la/Q02x3WXC0 #pgedge #postgresql #multiregion #postgresprofessionals

Check out this great new Blog written by #pgEdge experts, Michael Josephson and Susan Douglas, entitled, "Designing an Equinix Deployment with pgEdge Distributed PostgreSQL." Read it today to learn more: hubs.la/Q02vSlSf0 @PostgreSQL #postgresprofessionals #equinx

#pgEdge is excited to be a Partner Sponsor at this year's Postgres Conference 2024, this week in San Jose, CA. If you haven't registered yet, there's still time! Register now: hubs.la/Q02sTsCP0. @postgresworld @postgresconf @PostgreSQL @postgresprofessionals

#pgEdge. Fully distributed PostgreSQL, optimized for the network edge. Based on standard #Postgres and 100% open. Try the FREE download today! hubs.la/Q02kVSdD0 #postgresql @postgresprofessionals