cartero Wednesday, August 12, 2026 · No. 25957
PostgreSQL

Shinya Kato: 5 PostgreSQL locking behaviors that trip people up

Introduction PostgreSQL uses MVCC (Multi-Version Concurrency Control) for concurrency control: reads never block writes, and writes never block reads. Its locking system has 8 table-level lock modes and 4 row-level lock modes, and the conflict tables in the documentation tell you exactly which lock modes conflict with which. In practice, though, once you actually operate PostgreSQL, locks end up conflicting in places you never expected. Queries take far longer than anticipated, and in the...

RAG

Shaping Product Understanding with Contrastive Reinforcement Learning

Etsy’s marketplace is defined by the creativity and craftsmanship of our sellers and the hundreds of millions of highly diverse products they offer. You can find silversmiths who cold-forge recycled sterling silver, weavers who dye raw fleece with indigo and black walnut, and ceramicists who throw stoneware on a kick wheel. These details define each product and often determine whether it matches a buyer’s taste, style, and interests. Sometimes buyers know exactly what they want, searching...

PostgreSQL

Ashutosh Bapat: My Reflections on PGConf.dev 2026

From Ottawa to VancouverFor a long time, PGCon in Ottawa was a staple for the PostgreSQL community. I always had a soft spot for Ottawa; it fondly reminded me of my childhood days in Pune. So, when it was first announced that the reincarnated PGConf.dev would take place in Vancouver, I felt a twinge of sadness.However, the moment I landed in Vancouver, all my reservations dissolved. The city won me over instantly—from riding a bicycle along the seawall and admiring the beautiful totem poles...

PostgreSQL

Jeremy Schneider: PGConf.dev 2026 Trip Summary

I’m back home from Vancouver. What a great week – in every way. I’ll try to share a few highlights here. Updated Happiness Hints First and foremost: after many years, the Happiness Hints have received a major update! Before the conference, I updated the hints based on all the feedback I’ve collected over the past few years. Then the hints were updated into a poster format and we printed it as part of the pgconf.dev poster session. Throughout the week, I continued collecting ...

AI Coding Tools

Outcomes we want to see from AI at Medium Engineering

This was originally written and published by Christophe Spy (Director of Engineering, Medium) as an internal Medium Eng post.Desired outcomes (what “good” looks like)🙏🏻 These are the kinds of changes we want to see if AI is going well at Medium.Less drudgery, more leverageEngineers use AI to remove repetitive, low‑leverage work (e.g. tedious refactors, boilerplate, large test suites), not just to ship more tickets.We see examples like:“We took a part of the codebase that w...

Artificial Intelligence

Rockets, Poems, and AI: A Curiously Winding Path

"Innovation does not wear a uniform. It wears reading glasses, hiking boots, lab coats, business suits, and sometimes pajamas at 2 a.m."

Artificial Intelligence

Moltbook and Artificial (Proto) Life

"The way LLMs work with tokens reminds me of nascent proto life. Instead of base pairs and amino acids, we have tokens and transformer layers."

AI Agents

Orchestrating the Schema

"We are seeing a shift toward multi-agent systems that operate through a Reasoning-Actuation loop."

Space Tech

Computing in Orbit or on Extraterrestrial Bodies

It is a modest step to consider having AI agents operating in orbit to facilitate research, operating production facilities, and preserving data over long periods

Artificial Intelligence

Rethinking organizational design in the age of agentic AI

Amid rapidly growing adoption of enterprise-level AI agents, there’s a disconnect emerging between ambition and execution.  Although 85% of organizations say they want to be agentic within the next three years, 76% say their current operations and infrastructure can’t support that change. They cite a lack of readiness across people, processes, and workflows.  The sticky…

AI Psychosis

The End of the Digital Age

The tension between limitless replication of artifacts by computing and rightful attribution sits at the heart of the coming end of the digital age.

AI Agents

GeeCON 2026 — a recap

The 2026 edition of GeeCON didn’t look promising at first. I arrived in Kraków expecting the same slow decline I’d been hearing about — no crowds, only five sponsor booths, and talks from sponsors about their great products. Last year I heard the conference business was slowly dying, and I kinda agreed.

Meta

The Joy of Scope Creep

I’m disciplined about scope. Ship the smallest thing that moves you forward. The feature you don’t build is the feature you don’t maintain. When I was running a team, holding the why was the job. Keeping us focused on the things that actually mattered, and away from the things that didn’t. In Navigating the AI […]

Space Tech

The Download: puncturing the AI jobs panic

This is today’s edition of The Download, our weekday newsletter that provides a daily dose of what’s going on in the world of technology. A reality check on the AI jobs hysteria Despite the growing hysteria over AI’s threat to white-collar jobs, there’s still scant evidence that the technology has had a large-scale impact on…

Query Planning

Andrei Lepikhov: EXPLAIN Prettier, or Post-Processing Query Plans in Postgres

This story started with a book gifted by a colleague. Reading Jimmy Angelakos' «PostgreSQL Mistakes and How to Avoid Them», I realised something that had been bugging me - in Postgres, the EXPLAIN command produces far too much information. The examples that authors typically present when discussing various aspects of database systems make it harder to analyse the problem at hand and distract the reader. That's how the idea of a post-processing for EXPLAIN output was born - to make query pla...

Artificial Intelligence

Vibhor Kumar: AI Without Semantics Is Just Expensive Guessing

Why Metadata, Taxonomy, Ontology, Knowledge Graphs, and Context Are Becoming the Foundation of Enterprise AI The technology industry is entering a fascinating phase where many older ideas are suddenly becoming critically important again. Concepts that once lived mostly inside data governance discussions, library sciences, enterprise architecture diagrams, semantic web research, and metadata catalogs are now being pulled directly into the center of modern AI conversations. This shift is not...

Connection Pooling

SHRIDHAR KHANAL: Critical PMM Alerts Every PostgreSQL DBA Must Track

The Night When Things Almost Went DownHave you ever left for home on a Friday evening feeling confident about your work for the day, at peace knowing your system would survive the coming weekend? We’ve all felt that way at some point.Meanwhile, the disk on the server had quietly reached 90% utilization. Write-Ahead Log (WAL) files had accumulated enormously, one long-running query had been running for over an hour, and nobody noticed because, some time earlier, the dashboard had looked fine...

PostgreSQL

Would love feedback: we built a Postgres investigation layer for Postgres workloads

Hey everyone, we’ve been working on pgpulse (https://pgpulse.io), a Supabase-native PostgreSQL observability product, and I wanted to share one part of the thinking behind it and get feedback from people actually running apps on Supabase. A lot of tools are good at showing metrics and alerts, but when something goes wrong, the hard part is often investigation. Not necessarily fixing it. Not collecting more data. But reducing the time it takes to understand what is actually happening. That��...

PostgreSQL

Josef Machytka: The PostgreSQL Conference HOW2026 in Jinan, China

At the end of April, I had the incredible opportunity to represent credativ on the HOW2026 (Hello Open-source World), the PostgreSQL & IvorySQL Eco Conference in Jinan, China. IvorySQL is a Chinese fork of PostgreSQL with extended Oracle compatibility. In recent years, it has been gaining popularity not only in China. The conference brought together PostgreSQL and IvorySQL experts, contributors, and open-source database enthusiasts from around the world. The atmosphere was excellent, and I wo...

Artificial Intelligence

It’s time to address the looming crisis in entry-level work.

Artificial intelligence has not so far produced a clean story of mass unemployment. Aggregate employment in developed countries remains broadly stable, and recent assessments have found limited evidence that AI has shifted the headline numbers. But a troubling change may be hiding beneath the surface: the quiet weakening of the first rung of the career…

Artificial Intelligence

A reality check on the AI jobs hysteria

Haven’t you heard? White-collar jobs are going away, decimated by AI. Waves of layoffs in the tech sector (most recently at Coinbase and Meta and Cisco) are said to presage what will soon come for all of us knowledge workers. But before you quit your job as a software developer or financial analyst—or tech journalist—and…

PostgreSQL

Cornelia Biacsics: Contributions for week 20, 2026

PGConf.dev 2026 took place from May 19-22 2026, organized by Gwen Shapira Jonathan Katz Kaiting Chen Magnus Hagander Melanie Plageman Paul Ramsey Robert Haas Steve Singer Program Committee: Jacob Champion Jonathan Katz Dilip Kumar Melanie Plageman Paul Ramsey Tuesday Planning Committee: Claire Giordano Corey Huinker Matthias van de Meent Paul Jungwirth Robert Haas Code of Conduct Committee: Pavlo Golub Stacey Haysler Masahiko Sawada Volunteers: Alena Rybakina Álvaro Herrera Amit Kap...