Skip to content

Tag: PostgreSQL

  • SOW: Postpartum Care for 100,000 Packages

    By vonng In Articles 3362 words 16 min

    vonngPostgreSQLPigstyRepository

    SOW: Postpartum Care for 100,000 Packages

    Originally published on VONNG. Today, let’s talk about Postpartum Care for Sows—a Chinese meme for the sort of absurdly specialized practical topic nobody expects to discuss. This time, the sow in question is my new open-source project, SOW. When …

    Originally published on VONNG. Today, let’s talk about Postpartum Care for Sows—a Chinese meme for the sort of absurdly specialized practical topic nobody expects to discuss. This time, the sow in question is my new open-source project, SOW. When …

  • Instantly Clone PostgreSQL Databases—No Black Magic Required

    By vonng In Articles 718 words 4 min

    vonngPostgreSQLPigstyTools

    Instantly Clone PostgreSQL Databases—No Black Magic Required

    Originally published on VONNG. Six months ago, on January 8, 2026, I wrote Git for Data: Instant PostgreSQL Database and Instance Cloning, introducing a new feature in PostgreSQL 18 and Pigsty v4.0: instant database cloning. With filesystem …

    Originally published on VONNG. Six months ago, on January 8, 2026, I wrote Git for Data: Instant PostgreSQL Database and Instance Cloning, introducing a new feature in PostgreSQL 18 and Pigsty v4.0: instant database cloning. With filesystem …

  • What Is a PostgreSQL Distribution?

    By vonng In Articles 3222 words 16 min

    vonngPostgreSQLPigsty

    What Is a PostgreSQL Distribution?

    Originally published on VONNG. People often ask me: what exactly is Pigsty? My usual answer is: a PostgreSQL distribution. The next question is usually: what, then, is a “PostgreSQL distribution”? That is a good question. And the best place to begin …

    Originally published on VONNG. People often ask me: what exactly is Pigsty? My usual answer is: a PostgreSQL distribution. The next question is usually: what, then, is a “PostgreSQL distribution”? That is a good question. And the best place to begin …

  • Give DBA Agents a Body

    By vonng In Articles 4833 words 23 min

    vonngAIAgentPostgreSQLPigsty

    Give DBA Agents a Body

    Originally published on VONNG. HOW 2026 keynote: Give DBA Agents a Body Part I: Opening—An Absurd Phenomenon 1. Cover Hello, everyone. I’m Ruohang Feng, the organizer of this tools track. This is a PostgreSQL tools session, but today I don’t want to …

    Originally published on VONNG. HOW 2026 keynote: Give DBA Agents a Body Part I: Opening—An Absurd Phenomenon 1. Cover Hello, everyone. I’m Ruohang Feng, the organizer of this tools track. This is a PostgreSQL tools session, but today I don’t want to …

  • Put Your AI Agent's State in a Database

    By vonng In Articles 2099 words 10 min

    vonngPostgreSQLAIAgentPigsty

    Put Your AI Agent's State in a Database

    Originally published on VONNG. A year ago, I wrote an article called PGFS: Using a Database as a Filesystem. It started with a request from the Odoo community: make files and the PostgreSQL database recoverable together with point-in-time recovery, …

    Originally published on VONNG. A year ago, I wrote an article called PGFS: Using a Database as a Filesystem. It started with a request from the Odoo community: make files and the PostgreSQL database recoverable together with point-in-time recovery, …

  • The Agent Moat: Runtime

    In Articles 1832 words 9 min

    AIAgentPostgreSQLPigsty

    The Agent Moat: Runtime

    Originally published on VONNG. 3 AM. Database alerts are blowing up. You throw the alert info at a “top-tier” DBA Agent. It’s well-read — knows the PostgreSQL docs inside out, writes beautiful diagnostic SQL, can recite every kernel parameter from …

    Originally published on VONNG. 3 AM. Database alerts are blowing up. You throw the alert info at a “top-tier” DBA Agent. It’s well-read — knows the PostgreSQL docs inside out, writes beautiful diagnostic SQL, can recite every kernel parameter from …

  • Forging a China-Rooted, Global PostgreSQL Distro

    By vonng In Articles 530 words 3 min

    vonngPostgreSQLPigsty

    Forging a China-Rooted, Global PostgreSQL Distro

    Originally published on VONNG. Hi, I’m Feng Ruohang, author of Pigsty and an independent open-source contributor. Let’s talk about how to build a PostgreSQL distribution that is rooted in China and useful to the whole world. The question isn’t …

    Originally published on VONNG. Hi, I’m Feng Ruohang, author of Pigsty and an independent open-source contributor. Let’s talk about how to build a PostgreSQL distribution that is rooted in China and useful to the whole world. The question isn’t …

  • Self-Hosting Dify with PG, PGVector, and Pigsty

    By vonng In Articles 1238 words 6 min

    vonngPostgreSQLPigstyContainers

    Self-Hosting Dify with PG, PGVector, and Pigsty

    Originally published on VONNG. Dify – The Innovation Engine for GenAI Applications Dify is an open-source LLM app development platform. Orchestrate LLM apps from agents to complex AI workflows, with an RAG engine. Which claims to be more …

    Originally published on VONNG. Dify – The Innovation Engine for GenAI Applications Dify is an open-source LLM app development platform. Orchestrate LLM apps from agents to complex AI workflows, with an RAG engine. Which claims to be more …

  • Ready-to-Use PostgreSQL Distribution: Pigsty

    By vonng In Articles 2048 words 10 min

    vonngPostgreSQLPigstyRDS

    Ready-to-Use PostgreSQL Distribution: Pigsty

    Originally published on VONNG. What is Pigsty Pigsty is a ready-to-use production-grade open-source PostgreSQL distribution. A distribution refers to a complete database solution consisting of a database kernel and its suite of software packages. …

    Originally published on VONNG. What is Pigsty Pigsty is a ready-to-use production-grade open-source PostgreSQL distribution. A distribution refers to a complete database solution consisting of a database kernel and its suite of software packages. …