pgEdge

Andrei Lepikhov writes up a subtle planner problem: a query that's worked for years can start throwing errors after a database upgrade, not because the data or query changed, but because the optimizer got smarter. As he mentions in the article, "the problem is well known across database engines; what's missing is a systematic solution". Andrei's proposed fix for Postgres extends PostgreSQL's existing prosupport machinery with a new SupportRequestSafeEarlyEval request type that lets functions declare themselves unsafe for early evaluation. The branch is up for review and discussion is open on pgsql-hackers. 📖 https://hubs.la/Q04g-wk90 #postgresql #postgres #pghackers #queryoptimizer

Got something cool you built in Postgres? Hints, tips, a community issue worth talking through? Jimmy Angelakos announced the next PostgresEDI meetup: coming up this June 11. Drop Jimmy a note if you have an idea of what you'd like to present, or just show up to listen and join the discussions if that's more your speed. The usual rhythm: 6 PM doors at Paterson's Land (University of Edinburgh), pizza, talks at 7, then over to The Canons' Gait at 8:45 to keep the conversation going. We are a proud sponsor of #PostgresEDI. 🐘 🎙️ Register or pitch a talk: https://hubs.la/Q04gV6TL0 #postgresql #postgres #edinburgh #scotland #meetup #postgresedi #community

Wrapped up recording my talk for POSETTE: An Event for Postgres "Past, Present and Future: Logical Decoding & Replication in PostgreSQL" The talk will be live-streamed on June 18th at 10:30 AM CEST as part of Livestream 4. Talk details:  https://lnkd.in/g4R5GTVF The full POSETTE schedule has a fantastic lineup of talks worth checking out:  https://lnkd.in/gS3GxeCM A big thank you to Isaac Alves, My Nguyen, Linda Leste, Cornelia Biacsics, and Claire Giordano for all the support throughout the process. It's been a great first-time POSETTE speaking experience. #PostgreSQL #Postgres #POSETTE #LogicalReplication #OpenSource #Database

Did you know I'll be at PGConf.dev 🐘 doing things? • Beyond the source: the human architecture of PostgreSQL (Panel) https://lnkd.in/e7w4rJ-S • Establishing the PostgreSQL standard: What's Postgres compatible? (Community Discussion) https://lnkd.in/eMe_ptwJ • PostgreSQL Commitfest Metrics: A Quantitative Analysis (Talk w/ Andreas Scherbaum) https://lnkd.in/esAwnBzU Hit me up if you're coming! #Postgres #PostgreSQL #Developer #Conference #PGConfdev

Live and unscripted this June 2nd at 11 AM EST: pgEdge AI DBA Workbench technical walkthrough, with open Q&A throughout the session. Dave Page (CTO, longtime Postgres Core Team member, creator of pgAdmin), Antony Pegg (Director of Product Management), and Paul Rothrock (Solutions Engineer) will demo how the Workbench actually operates against real Postgres estates. On the agenda: 📊 AI summaries of your Postgres estate, with drill-down to cluster, server, and database metrics 🚨 Three-tier anomaly detection: statistical baselines, vector similarity, LLM classification 🧠 Ellie, the built-in AI assistant, with 21 MCP tools, a RAG knowledge base, and persistent memory 🔔 Alerting channels, blackout windows, RBAC config 🐳 Docker Compose setup, self-hosted and air-gap ready, with Claude, OpenAI, Gemini, or local Ollama Bring a specific use case, design question, or stress-test scenario for the live Q&A. The Workbench is 100% open source and works with any Postgres 14+. That covers any mainstream DBaaS including Amazon RDS, Azure Database for PostgreSQL, Google Cloud SQL, and Supabase. No migration required. Point it at what you already run. 📅 Register: https://hubs.la/Q04gJ4Wv0 ☕ Code: https://hubs.la/Q04gJDsS0 #postgres #postgresql #dba #monitoring #aiengineering #opensource #webinar

Stop putting numbers inside parentheses after VARCHAR. That's the argument from this week's PG Phriday by Shaun Thomas. The number is catalog metadata. It gets baked into every view, materialized view, function with typed parameters, and composite type that touches the column. Change VARCHAR(10) to VARCHAR(15) on a mature schema and you're dropping and recreating a dozen dependent objects in the right order, in a transaction you're hoping doesn't fail at step eleven. Use TEXT plus a named CHECK constraint instead. Same enforcement, with the added benefits of regex patterns, multi-clause checks, and constraint names that actually show up in your 3 AM error logs. Independent of the dependency graph. Swappable in one ALTER. Performance hit on 10M rows: about 66 nanoseconds per row. As Shaun puts it: "we may as well quibble about the weight of the paint on a freight train." 📖 https://hubs.la/Q04gP4Mb0 #postgres #postgresql #pgphriday #sql #dba #database #opensource #programming #learntocode

Come see Hari Kiran and Jimmy Angelakos at PGConf.dev 🐘, covering important topics like how to get started contributing to the PostgreSQL Global Development Group project as well as info on the human architecture behind Postgres that makes up the greater community. 🌍 🌎 🌏 🐘 Looking forward to the sessions? 💬 #dev #developer #postgresql #postgres #data #opensource #linuxfoundation #rails

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: 📖 https://hubs.la/Q04gCgRP0 Find the extension on GitHub: ⭐ https://hubs.la/Q04gCfG30 #postgres #postgresql #dba #monitoring #observability #aiengineering #extensions #opensource #postgresprofessionals

Thinking about trying the AI DBA Workbench against your Supabase project? Now there are two ways to follow along. 📖 Muhammad Imtiaz's step-by-step blog walkthrough: https://hubs.la/Q04gC9Sr0 🎥 Or watch Paul Rothrock demo it in a new short video: https://hubs.la/Q04gC9Rv0 Either path gets you in-depth continuous monitoring, alerting, and Postgres tuning insights on top of your Supabase stack. Free and open source under the PostgreSQL License. #postgres #postgresql #supabase #dba #monitoring #opensource #data #dataanalysis #auditing #metrics #metricscollection

We are pleased to welcome pgEdge as a Bronze Sponsor ⭐ Thank you for supporting PG Data 2026 and our community 🤝 Learn more: http://www.pgedge.com/ #PGData #PGData2026 #PostgreSQL 🐘 #TechCommunity #DataEngineering #OpenSource #Sponsorship