Improving RAG in PostgreSQL: From basic retrieval to smarter context

In my previous blog post, we built the simplest possible Retrieval Augmented Generation (RAG) pipeline inside PostgreSQL. We embedded our manuals, stored those vectors in a table, ran a similarity search, and handed the top 5 results straight to a Large Language Model. The result was encouraging, we could already see the model drawing on our content rather than inventing information. But as with...
Detection and resolution of conflicts in PostgreSQL logical replication

At this year’s PGConf.dev, the premier gathering for PostgreSQL contributors, developers, and community leaders, Zhijie Hou and I had the opportunity talk about the challenges and solutions around conflict handling in logical replication — a topic increasingly relevant as PostgreSQL adoption continues to grow.