iiinova — where your digital self keeps evolving

pgEdge Postgres @pgedge.bsky.social · 3h

Where does an AI coding agent's test data go when the experiment ends? In pgEdge Starfleet, each agent gets its own copy-on-write #Postgres branch, deleted with it. Schema changes ship as migrations with the code. Via The New Stack: 📖 thenewstack.io/pgedge-starf... #AI #PostgreSQL #OpenSource #Data

020

pgEdge Postgres @pgedge.bsky.social · 28/09/2026

Postgres Summit US 2026 starts tomorrow in NYC (Sept 30-Oct 2). Phillip Merrick keynotes Wed on our 3 #OpenSource agentic AI tools for Postgres & the guardrails that matter once agents touch production data. postgresql.us/events/postg... #PostgreSQL #AgenticAI #NYC

020

pgEdge Postgres @pgedge.bsky.social · 28/09/2026

pgEdge Starfleet launched today for flexible #PostgreSQL deployment anywhere you need it with features like #MCP, #RAG, and true DB branching. CIO: "The biggest win for developers is not having to rewrite the app for production." - analyst Michael Leone. 📖 www.cio.com/article/4226... #Postgres

cio.com

Starfleet will fly Postgres AI apps from prototype to production, says pgEdge

Starfleet could help enterprises close the gap between AI prototypes and production by giving developers a path to avoid rewrites while giving IT greater control over deployment, analysts say.

120

pgEdge Postgres @pgedge.bsky.social · 28/09/2026

💫 Introducing pgEdge Starfleet: a #Postgres cloud platform built to take AI apps from prototype to production. Start with a single database, add built-in #MCP & #RAG servers, and deploy in production on pgEdge-hosted cloud, your cloud, or on-prem. www.pgedge.com/press-releas... #PostgreSQL #Tech

020

pgEdge Postgres @pgedge.bsky.social · 11/09/2026

pg_replslot can balloon overnight, then vanish by morning, no error, no trace. Each subscriber gets its own decoder, so one transaction spills once per subscription, not once total. PG18 fixed it - read more in this week's #PGPhriday from Shaun Thomas: www.pgedge.com/blog/pg-phri... #PostgreSQL

001

pgEdge Postgres @pgedge.bsky.social · 11/09/2026

The 8pm speaker slot at #PostgresEDI is still open. Thursday 24 Sept, 6pm, Paterson's Land, Edinburgh. Free, with pizza 🍕 Jimmy Angelakos opens at 19:00 on ColdFront: #OpenSource #Postgres data tiering to Apache Iceberg. Want the other slot? ✉️ vyruss000@gmail.com cloomba.com/e/postgresed...

020

pgEdge Postgres @pgedge.bsky.social · 26/08/2026

work_mem miscalibrated = disk spills (10x slower) or OOM crash on a busy day. It's per operation, not per query - one connection multiplies fast. Shaun Thomas on #Postgres FM: use pg_stat_database avg temp file sizes + padding. Cuts spills 90%+. 🎙️ postgres.fm/episodes/est... #database #postgresql

010

pgEdge Postgres @pgedge.bsky.social · 22/08/2026

Shaun Thomas on UUID v7 in #Postgres 18: v4 inserts land at random B-tree pages. Cache misses, page splits, 25% index bloat. v7 timestamps the high bits - new keys sort right, zero fragmentation. www.pgedge.com/blog/the-tim... #PostgreSQL #DBA #Unix #Programming #OpenSource #Hacking

pgedge.com

The Time Traveler's Primary Key

UUID v7 lands in PostgreSQL 18. Here's a benchmark comparison against v4 from Shaun Thomas on index size, fragmentation, and when you should still reach for something else.

010

pgEdge Postgres @pgedge.bsky.social · 14/08/2026

ColdFront: an #OpenSource solution to move cold #Postgres data to #ApacheIceberg without making it read-only. pgEdge's Jimmy Angelakos built it & explains his design decisions on Aug 19, 8 AM PT. Paul Rothrock follows with a live demo. Register: us02web.zoom.us/webinar/regi... #tech #postgresql

010

pgEdge Postgres @pgedge.bsky.social · 05/08/2026

👋 Hey #PostgreSQL folks in #Edinburgh: Thursday 13 August, 6 PM, University of Edinburgh. Two talks: Torsten Förtsch on escaping cloud lock-in with <100 lines of jq, and Paolo Guagliardo on why NULL is broken (and a fix). Pizza. Pub after. Register: 📆 cloomba.com/e/postgresql... #Scotland #UK #Tech

cloomba.com

PostgreSQL Edinburgh Meetup August 2026

Be part of our Edinburgh PostgreSQL Meetup! Join the PostgreSQL Edinburgh organisers and fellow PostgreSQL enthusiasts at Room LG45, Paterson's Land, University of Edinburgh! Connect with peers (all l...

000

pgEdge Postgres @pgedge.bsky.social · 05/08/2026

Next Tuesday: the engineer who built #OpenSource, transparent hot/cold tiering for #Postgres (ColdFront) will discuss the architecture live. #PostgreSQL to #ApacheIceberg: same SQL & table names, with a writable cold tier. August 19, 8 AM PST. Q&A at the end. 📅 us02web.zoom.us/webinar/regi... #tech

010

pgEdge Postgres @pgedge.bsky.social · 03/08/2026

Shaun Thomas wrote a #Postgres extension to prevent DDL. Why? So you get a guide to building one yourself. PG_MODULE_MAGIC (yes, really), ProcessUtility hooks, GUCs. "Gleeful madness when you realize how deep the extension rabbit-hole goes." 📖 hubs.la/Q04rLWYM0 #PostgreSQL #programming #tech #dev

010

pgEdge Postgres @pgedge.bsky.social · 31/07/2026

Someone filed a patch because `CURRENT_TIMESTAMP - (random() * interval '365 days')` is not a personality. #Postgres 19: typed random() for dates, pg_get_role_ddl() and friends. No theme. It's the Cult of Functionality. 📖 www.pgedge.com/blog/looking... #techblog #tech #postgresql #postgresql19 #sql

000

pgEdge Postgres @pgedge.bsky.social · 31/07/2026

Cold data that's still writable (yes, really). In-process DuckDB, no sidecar, same table names, same SQL, 100% open source PostgreSQL to Apache Iceberg. Register to attend the ColdFront live demo August 19 with the dev who built it: 📅 us02web.zoom.us/webinar/regi... #Programming #Tech #Podcast

010

pgEdge Postgres @pgedge.bsky.social · 31/07/2026

Scoping a 100% #OpenSource website chatbot? pgEdge AI Toolkit keeps the full RAG pipeline in #Postgres - Docloader, Vectorizer, RAG Server. Same stack as Ellie, our #AI assistant (demo it on pgedge.com). Works on any Postgres 14+, #PostgreSQL licensed. 🛠️ www.pgedge.com/download/ai-... #dev #tech

010

pgEdge Postgres @pgedge.bsky.social · 30/07/2026

#PostgresEDI is the #Edinburgh Postgres meetup - practitioner talks, real discussion, no vendor fluff. Last session covered #AI audit trails in #Postgres and breaking into the speaking circuit. Organized by pgEdge's Jimmy Angelakos. Next one: August 13. 📅 hubs.la/Q04rfmBk0 #PostgreSQL #Scotland

hubs.la

PostgreSQL Edinburgh Meetup August 2026

000

pgEdge Postgres @pgedge.bsky.social · 29/07/2026

We don't let a single developer push to production without review. So why do we let #AI agents run unmonitored? Shaun Thomas on autonomous agents, where they go wrong, and why #Postgres - not #pgvector - is the answer. 📖 www.pgedge.com/blog/going-r... #agenticai #llm #programming #tech #postgresql

010

pgEdge Postgres @pgedge.bsky.social · 29/07/2026

Most #Postgres data sits on expensive SSD nobody's queried in months. ColdFront (open source) moves it to #Apache #Iceberg - up to 90% cheaper - same SQL, same table names, no app changes. Jimmy Angelakos & Paul Rothrock demo it live 8/19, 8 AM PST. 📅 hubs.la/Q04rdpHQ0 #programming #postgresql #dba

010

pgEdge Postgres @pgedge.bsky.social · 21/07/2026

Three pgEdge team members are presenting at PGConf.EU 2026 (Oct 20-23, Valencia): Andrei Lepikhov on query planner visibility, Jimmy Angelakos on agentless #PostgreSQL diagnostics, & Ibrar Ahmed on disaster recovery. Proud Gold Sponsor. www.postgresql.eu/events/pgcon... #tech #technews #europe #sql

010

pgEdge Postgres @pgedge.bsky.social · 21/07/2026

🐘 pgEdge is a 100% open-source, #Postgres licensed company delivering #PostgreSQL infrastructure for appdevs - including those working with #AgenticAI & those in regulated industries (govt, healthcare, finance). Focus in HA, security, data sovereignty, global deployment. pgedge.com github.com/pgedge

pgedge.com

Enterprise Postgres for Agentic AI | pgEdge

Run Enterprise PostgreSQL with built-in agentic AI tooling, multi-master replication, and zero-downtime HA. Self-hosted, cloud, or managed by pgEdge.

030