| Website | https://www.pgedge.com |
| https://www.linkedin.com/company/pgedge/ | |
| Discord | https://discord.com/invite/pgedge/login |
| GitHub | https://github.com/pgedge |
Got something cool you built in Postgres? Hints, tips, a community issue worth talking through? @vyruss announced the next PostgresEDI meetup: coming up this June 11.
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://luma.com/cnygmdv1
#postgresql #postgres #edinburgh #scotland #meetup #community
Last night I gave a lightning talk about ROLLUP and CUBE at the @PostgresEDI Edinburgh PostgreSQL meetup. Code and slides are at https://github.com/jimgar/pg-rollups
If you have some groups and want aggregate stats for them, you probably reach for GROUP BY. But what you may **need** is ROLLUP or CUBE, both of which elegantly extend what's possible with grouped aggregates. If that piques your interest, the official docs on the topic are very good! https://www.postgresql.org/docs/current/queries-table-expressions.html
Call for Participation for our June 11th @PostgresEDI #meetup: if you have something cool you built, hints and tips to share, or #PostgreSQL #community issues to discuss, we'd be delighted to have you on our stage!
pg_statviz 1.0 is out: New! Improved! Now with AI! (Optional, of course.) Per-chart verdicts and remediation for your PostgreSQL stats.
https://vyruss.org/blog/pg_statviz-1-0-released-ai-analysis.html
Extension pg_statviz for time series analysis & visualization of Postgres internal statistics has released version 1.0 with an optional AI analysis mode that produces per-module HTML reports with chart commentary, threshold verdicts, and concrete remediation advice from a cloud or local LLM.
Did you know I'll be at @pgconfdev doing things?
• Beyond the source: the human architecture of PostgreSQL (Panel) https://2026.pgconf.dev/session/558
• Establishing the PostgreSQL standard: What's Postgres compatible? (Community Discussion) https://2026.pgconf.dev/session/450
• PostgreSQL Commitfest Metrics: A Quantitative Analysis (Talk w/ @ascherbaum) @https://2026.pgconf.dev/session/635
Hit me up if you're coming!
Big news from @vyruss: pg_statviz 1.0 ships with optional AI analysis. 🐘
Each chart gets a [HEALTHY]/[WARNING]/[CRITICAL] verdict with remediation advice from Claude, Gemini, or local Ollama.
Two smart design choices:
🛡️ Deterministic rules run before the LLM, with a severity floor that prevents downgrading real problems
📐 Calibration block debunks #Postgres myths (25% RAM for shared_buffers, default random_page_cost=4)
https://vyruss.org/blog/pg_statviz-1-0-released-ai-analysis.html
We are pleased to welcome @pgEdgeDistributedPostgres 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
Most monitoring tools forget you the second you close the tab. The pgEdge AI DBA Workbench remembers.
Pin context like "our busiest period is 2 to 4pm EST" once and it rides along in every future investigation, even across team handoffs. Stored as embeddings with semantic recall, so the right note surfaces automatically.
Open source under the PostgreSQL License.
📥 https://www.pgedge.com/download/ai-dba-workbench
#postgres #postgresql #dba #monitoring #aiengineering #opensource
#Spock 5.0.7 is out. 🐘
Logical slot failover on #PostgreSQL 17 and 18 now integrates with PG's native slotsync worker. On PG18+, Spock's own failover_slots worker is retired entirely.
Plus fixes for add-node data races, apply worker crashes after provider disconnects, and exception_log error message quality.
Open source under the PostgreSQL License. Logical multi-master replication for PostgreSQL 15, 16, 17, and 18.
📖 Release notes: https://github.com/pgEdge/spock/blob/v5_STABLE/docs/spock_release_notes.md
Huge thanks to everyone who came out to last month's @PostgresEDI! Sharp questions, great talks, and fun pub conversation afterward. 🍕🐘
Next one is 5/7 at the University of Edinburgh: lightning talks only, a low-pressure warm-up for the PGDay UK CFP (deadline 5/12).
Doors at 6, talks at 7, post-meetup at The Canons' Gait.
Proud to be a sponsor. Huge thanks to @vyruss for organizing!
🔗 Register: https://hubs.la/Q04dWp0v0
#postgresql #postgres #edinburgh #meetup #pgday #scotland #postgresedi
Jim Gardner
Jimmy Angelakos 
PGDATA 2026