iiinova — where your digital self keeps evolving

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

In #PostgreSQL, using NOT IN to exclude rows is a mistake. It's the first one in Jimmy Angelakos's book PostgreSQL Mistakes and How to Avoid Them. Free signed copies at the pgEdge table, PGConf.EU 2026, #Valencia, Tue Oct 20. 📖 www.manning.com/books/postgr... #Postgres #Tech #Europe #Spain

220

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

In PostgreSQL, 1.5 and 1.50 are equal as numeric, but cast to text and you get two different strings 🐘 Andrei Lepikhov traces why numeric aggregation costs more than double precision, then compares DuckDB’s DECIMAL 🦆 📖 www.pgedge.com/blog/why-is-... #postgres #postgresql #data #tech #technology

000

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

Much "database branching" in Postgres clouds only branches schema, not data, or rewrites the storage engine. pgEdge Starfleet does true copy-on-write branching without replacing the Postgres storage layer. Free 14-day trial, no credit card: 🚀 app.pgedge.com #PostgreSQL #OpenSource

010

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

Going to #PGConfEU2026 in Valencia, Oct 20-22? pgEdge is a Gold Sponsor. Meet Jimmy Angelakos (panel Tue, radar talk Thu, book signing Tue), Dr. Ibrar Ahmed (Tue) & Phillip Merrick (Wed). Table 6, Main Hall. 🎙️ www.postgresql.eu/events/pgcon... #PostgreSQL

000

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

Tonight at the London PostgreSQL meetup, pgEdge's Jimmy Angelakos presents ColdFront (public beta): data tiering to Apache Iceberg on S3, same SQL, writable cold tier. 20:15, registration required: 🎙️ www.meetup.com/london-postg... #PostgreSQL #ApacheIceberg

000

pgEdge Postgres @pgedge.bsky.social · 06/10/2026

Postgres Summit US 2026 wrapped up Friday in NYC. Thanks to the organizers (including our own Mark Wong) & everyone who stopped by our table. Discord: hubs.la/Q04zgc_G0 Try pgEdge Starfleet, our Postgres cloud platform, free for 14 days: hubs.la/Q04zgcSP0 #PostgresSummit #PostgreSQL #Postgres #NYC

010

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

"Unix philosophy got here first: instead of one agent doing everything, break the work into steps and assign each step its own agent." Phillip Merrick on increasing accuracy and efficiency of AI agents - read more: 📖 drive.starcio.com/2026/10/thou... #AIAgents #AgenticAI #DevOps

drive.starcio.com

Thousands of AI Agents: 13 C-Level Leaders With New Responsibilities

Exponential increases in deployed AI agents requires new C-level leadership roles around growth, architecture, people/process, and risk management.

010

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

Phillip Merrick on pgEdge Starfleet: build apps on Postgres that deploy to "the same database that many IT teams run in production environments." Via Techstrong IT 📖 techstrong.it/featured/pge... #Postgres #technology #technews

000

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

Dave Page, pgEdge CTO and PostgreSQL Core Team member, on where #AI fits for DBAs: not replacing them, but following a process more consistently than a person under pressure. 📖 www.infoworld.com/article/4218... #PostgreSQL #Tech #Data #Postgres #OpenSource #Technology #News #Programming

010

pgEdge Postgres @pgedge.bsky.social · 02/10/2026

PostgreSQL 19 lost six features to reverts, including GROUP BY ALL & SQL/PGQ property graphs. Shaun Thomas on why: heavier scrutiny, AI-assisted review included, is catching bugs that once surfaced in dot releases. 📖 www.pgedge.com/blog/looking... #PostgreSQL #Postgres #Data #PG19 #Engineering

000

pgEdge Postgres @pgedge.bsky.social · 02/10/2026

Most vendors give you high availability OR zero-downtime maintenance on #Postgres - rarely both. pgEdge Starfleet scales from a single instance to a multi-region, zero-downtime cluster with optional active-active replication. Standard #PostgreSQL the whole way. 📖 www.pgedge.com/products/sta...

000

pgEdge Postgres @pgedge.bsky.social · 01/10/2026

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