Blog Columns
Six thematic columns, each with its own dedicated RSS feed.
Database Guru
77posts
Database news, industry surveys, architecture, and best practices.
Cloud-Exiter
67posts
Cloud economics, repatriation, and building sovereign infrastructure.
Postgres Mage
130posts
PostgreSQL ecosystem, internals, extensions, and production tuning.
AI Agent Explorer
100posts
Practical engineering with coding agents, LLMs, AI4DB, and DB4AI.
Travel Notes
12posts
Trips, hikes, landscapes, and field notes across mountains and seas.
Miscellaneous
41posts
Essays, reflections, and personal writing inside and outside of tech.

Are Cloud Databases an IQ Tax?
Winter is coming, tech giants are laying off workers entering cost-reduction mode. Can cloud databases, the number one public cloud cash cow, still tell their story? The money you spend on cloud …

How Powerful is PostgreSQL Really?
Let performance data speak: Why PostgreSQL is the world's most advanced open-source relational database, aka the world's most successful database. MySQL vs PostgreSQL performance showdown and …

Why PostgreSQL is the Most Successful Database?
Database users are developers, but what about developers' preferences, likes, and choices? Looking at StackOverflow survey results over the past six years, it's clear that in 2022, PostgreSQL has won …

Post-90s, Quit Job to Start Business, Says Will Crush Cloud Databases
Recently gave an interview to OSC Open-Source China, discussing the motivation behind quitting my full-time job to start a business with Pigsty: making PostgreSQL easy to use for everyone, and …

Pigsty v1.5: Docker Application Support, Infrastructure Self-Monitoring
Complete Docker support, infrastructure self-monitoring, ETCD as DCS, better cold backup support, and CMDB improvements.

Is DBA Still a Good Job?
Ant Financial had a self-deprecating joke: besides regulation, only DBAs could bring down Alipay. Although DBA sounds like a profession with glorious history and dim prospects, who knows if it might …

Cloud RDS: From Database Drop to Exit
I recently witnessed a live cloud database drop-and-run incident. This article discusses how to handle accidentally deleted data when using PostgreSQL in production environments.

Pigsty v1.4: Modular Architecture, MatrixDB Data Warehouse Support
Pigsty v1.4 introduces a modular architecture with four independent modules, adds MatrixDB time-series data warehouse support, and delivers global CDN acceleration.

Pigsty v1.3: Redis Support, PGCAT Overhaul, PGSQL Enhancements
Pigsty v1.3 adds Redis support with three deployment modes, rebuilds the PGCAT catalog explorer, and enhances PGSQL monitoring dashboards.

Pigsty v1.2: PG14 Default, Monitor Existing PG
Pigsty v1.2 makes PostgreSQL 14 the default version and adds support for monitoring existing database instances independently.

Pigsty v1.1: Homepage, Jupyter, Pev2, PgBadger
Pigsty v1.1.0 ships with a redesigned homepage, plus JupyterLab, PGWeb, Pev2 & PgBadger integrations.

The WeChat Photo Album Access Issue
I saw news about WeChat accessing user photo albums in the background. While such shady behavior from Chinese apps doesn't surprise me, in the spirit of seeking truth, I got up this morning to …

Life at 28
My solar birthday falling on Mid-Autumn Festival is something that will only happen three times in my lifetime. Theoretically, this should be a memorable day, but the events of this year have left me …

Pigsty v1.0: GA Release with Monitoring Overhaul
Pigsty v1.0.0 GA is here — a batteries-included, open-source PostgreSQL distribution ready for production.

Majestic Southern Taihang
From Xinxiang, Henan, crossing the Taihang Mountains to Shanxi

On the Hills of Manchuria
Standing on the hills of Manchuria, on the grasslands of Hulunbuir.

Ready-to-Use PostgreSQL Distribution: Pigsty
Yesterday I gave a live presentation in the PostgreSQL Chinese community, introducing the open-source PostgreSQL full-stack solution — Pigsty

Why Does PostgreSQL Have a Bright Future?
Databases are the core component of information systems, relational databases are the absolute backbone of databases, and PostgreSQL is the world's most advanced open source relational database. With …

Pigsty v0.9: CLI + Logs
One-click installs, a beta CLI, and Loki-based logging make Pigsty easier to land.

Pigsty v0.8: Service Provisioning
Services are now first-class objects, so you can define any routing policy—built-in HAProxy, L4 VIPs, or your own balancer.

Localization and Collation Rules in PostgreSQL
What? Don't know what COLLATION is? Remember one thing: using C COLLATE is always the right choice!

Implementing Advanced Fuzzy Search
How to implement relatively complex fuzzy search logic in PostgreSQL?

PostgreSQL Logical Replication Deep Dive
This article introduces the principles and best practices of logical replication in PostgreSQL 13.

PG Replica Identity Explained
Replica identity is important - it determines the success or failure of logical replication

Are Cloud Databases an IQ Tax?
Winter is coming, tech giants are laying off workers entering cost-reduction mode. Can cloud databases, the number one public cloud cash cow, still tell their story? The money you spend on cloud …

How Powerful is PostgreSQL Really?
Let performance data speak: Why PostgreSQL is the world's most advanced open-source relational database, aka the world's most successful database. MySQL vs PostgreSQL performance showdown and …

Why PostgreSQL is the Most Successful Database?
Database users are developers, but what about developers' preferences, likes, and choices? Looking at StackOverflow survey results over the past six years, it's clear that in 2022, PostgreSQL has won …

Post-90s, Quit Job to Start Business, Says Will Crush Cloud Databases
Recently gave an interview to OSC Open-Source China, discussing the motivation behind quitting my full-time job to start a business with Pigsty: making PostgreSQL easy to use for everyone, and …

Pigsty v1.5: Docker Application Support, Infrastructure Self-Monitoring
Complete Docker support, infrastructure self-monitoring, ETCD as DCS, better cold backup support, and CMDB improvements.

Is DBA Still a Good Job?
Ant Financial had a self-deprecating joke: besides regulation, only DBAs could bring down Alipay. Although DBA sounds like a profession with glorious history and dim prospects, who knows if it might …

Cloud RDS: From Database Drop to Exit
I recently witnessed a live cloud database drop-and-run incident. This article discusses how to handle accidentally deleted data when using PostgreSQL in production environments.

Pigsty v1.4: Modular Architecture, MatrixDB Data Warehouse Support
Pigsty v1.4 introduces a modular architecture with four independent modules, adds MatrixDB time-series data warehouse support, and delivers global CDN acceleration.

Pigsty v1.3: Redis Support, PGCAT Overhaul, PGSQL Enhancements
Pigsty v1.3 adds Redis support with three deployment modes, rebuilds the PGCAT catalog explorer, and enhances PGSQL monitoring dashboards.

Pigsty v1.2: PG14 Default, Monitor Existing PG
Pigsty v1.2 makes PostgreSQL 14 the default version and adds support for monitoring existing database instances independently.

Pigsty v1.1: Homepage, Jupyter, Pev2, PgBadger
Pigsty v1.1.0 ships with a redesigned homepage, plus JupyterLab, PGWeb, Pev2 & PgBadger integrations.

The WeChat Photo Album Access Issue
I saw news about WeChat accessing user photo albums in the background. While such shady behavior from Chinese apps doesn't surprise me, in the spirit of seeking truth, I got up this morning to …

Life at 28
My solar birthday falling on Mid-Autumn Festival is something that will only happen three times in my lifetime. Theoretically, this should be a memorable day, but the events of this year have left me …

Pigsty v1.0: GA Release with Monitoring Overhaul
Pigsty v1.0.0 GA is here — a batteries-included, open-source PostgreSQL distribution ready for production.

Majestic Southern Taihang
From Xinxiang, Henan, crossing the Taihang Mountains to Shanxi

On the Hills of Manchuria
Standing on the hills of Manchuria, on the grasslands of Hulunbuir.

Ready-to-Use PostgreSQL Distribution: Pigsty
Yesterday I gave a live presentation in the PostgreSQL Chinese community, introducing the open-source PostgreSQL full-stack solution — Pigsty

Why Does PostgreSQL Have a Bright Future?
Databases are the core component of information systems, relational databases are the absolute backbone of databases, and PostgreSQL is the world's most advanced open source relational database. With …

Pigsty v0.9: CLI + Logs
One-click installs, a beta CLI, and Loki-based logging make Pigsty easier to land.

Pigsty v0.8: Service Provisioning
Services are now first-class objects, so you can define any routing policy—built-in HAProxy, L4 VIPs, or your own balancer.

Localization and Collation Rules in PostgreSQL
What? Don't know what COLLATION is? Remember one thing: using C COLLATE is always the right choice!

Implementing Advanced Fuzzy Search
How to implement relatively complex fuzzy search logic in PostgreSQL?

PostgreSQL Logical Replication Deep Dive
This article introduces the principles and best practices of logical replication in PostgreSQL 13.

PG Replica Identity Explained
Replica identity is important - it determines the success or failure of logical replication
Are Cloud Databases an IQ Tax?

Winter is coming, tech giants are laying off workers entering cost-reduction mode. Can cloud databases, the number one public cloud cash cow, still tell their story? Recently, an article by DHH, co-founder of Basecamp & HEY, caused a stir【1,2】. The …
Winter is coming, tech giants are laying off workers entering cost-reduction mode. Can cloud databases, the number one public cloud cash cow, still tell their story? Recently, an article by DHH, co-founder of Basecamp & HEY, caused a stir【1,2】. The …
How Powerful is PostgreSQL Really?

Previously, we analyzed StackOverflow survey data to explain “Why PostgreSQL is the Most Successful Database”. This time we’ll let performance data speak for itself, discussing just how powerful the most successful PostgreSQL really is, helping you …
Previously, we analyzed StackOverflow survey data to explain “Why PostgreSQL is the Most Successful Database”. This time we’ll let performance data speak for itself, discussing just how powerful the most successful PostgreSQL really is, helping you …
Why PostgreSQL is the Most Successful Database?

When we say a database is “successful,” what exactly do we mean? Is it about features, performance, usability, or cost, ecosystem, complexity? There are many metrics, but ultimately users decide. Database users are developers, so what about …
When we say a database is “successful,” what exactly do we mean? Is it about features, performance, usability, or cost, ecosystem, complexity? There are many metrics, but ultimately users decide. Database users are developers, so what about …
Post-90s, Quit Job to Start Business, Says Will Crush Cloud Databases

Original WeChat Article | Open-Source China Article Published by: OSCHINA Open-Source China Interviewee: Feng Ruohang (Pigsty Founder) Feng Ruohang has been quite busy lately. After a startup camp pitch in June, he added two to three hundred …
Original WeChat Article | Open-Source China Article Published by: OSCHINA Open-Source China Interviewee: Feng Ruohang (Pigsty Founder) Feng Ruohang has been quite busy lately. After a startup camp pitch in June, he added two to three hundred …
Pigsty v1.5: Docker Application Support, Infrastructure Self-Monitoring

GitHub Release | Release Note Pigsty v1.5 is officially released! Complete Docker support brings a rich application ecosystem — countless database-backed software works out of the box! Other improvements include: infrastructure self-monitoring, …
GitHub Release | Release Note Pigsty v1.5 is officially released! Complete Docker support brings a rich application ecosystem — countless database-backed software works out of the box! Other improvements include: infrastructure self-monitoring, …
Is DBA Still a Good Job?

Ant Financial had a self-deprecating joke: besides regulation, only DBAs could bring down Alipay. In the digital age, data is the core asset of many enterprises, especially for internet/software service companies. The people responsible for …
Ant Financial had a self-deprecating joke: besides regulation, only DBAs could bring down Alipay. In the digital age, data is the core asset of many enterprises, especially for internet/software service companies. The people responsible for …
Cloud RDS: From Database Drop to Exit

In my previous article “Is DBA Still a Good Job”, I mentioned: Although DBA as a profession is declining, who knows if DBAs might become trendy again after several terrifying large-scale cloud database failures. Well, I recently witnessed a live …
In my previous article “Is DBA Still a Good Job”, I mentioned: Although DBA as a profession is declining, who knows if DBAs might become trendy again after several terrifying large-scale cloud database failures. Well, I recently witnessed a live …
Pigsty v1.4: Modular Architecture, MatrixDB Data Warehouse Support

GitHub Release | Release Note Pigsty v1.4 is officially released! A brand new modular architecture: four built-in modules INFRA, NODES, PGSQL, REDIS can be used independently and freely combined; new MatrixDB time-series data warehouse deployment …
GitHub Release | Release Note Pigsty v1.4 is officially released! A brand new modular architecture: four built-in modules INFRA, NODES, PGSQL, REDIS can be used independently and freely combined; new MatrixDB time-series data warehouse deployment …
Pigsty v1.3: Redis Support, PGCAT Overhaul, PGSQL Enhancements

GitHub Release | Release Note Pigsty v1.3 is officially released, featuring Redis support, a rebuilt PGCAT application, and enhanced PGSQL monitoring. Redis Support While PostgreSQL is the world’s most advanced open-source relational database, every …
GitHub Release | Release Note Pigsty v1.3 is officially released, featuring Redis support, a rebuilt PGCAT application, and enhanced PGSQL monitoring. Redis Support While PostgreSQL is the world’s most advanced open-source relational database, every …
Pigsty v1.2: PG14 Default, Monitor Existing PG

GitHub Release | Release Note Pigsty v1.2 is officially released, making PostgreSQL 14 the default version and adding support for monitoring existing database instances independently. PostgreSQL 14 Becomes the Default PostgreSQL 14 was released last …
GitHub Release | Release Note Pigsty v1.2 is officially released, making PostgreSQL 14 the default version and adding support for monitoring existing database instances independently. PostgreSQL 14 Becomes the Default PostgreSQL 14 was released last …
Pigsty v1.1: Homepage, Jupyter, Pev2, PgBadger

GitHub Release | Release Note Pigsty v1.1 is officially released, featuring a brand-new homepage design, plus support for JupyterLab, PGWeb, PEV2, PgBadger, and other useful tools. Brand New Homepage The Home Dashboard in Grafana has long served as …
GitHub Release | Release Note Pigsty v1.1 is officially released, featuring a brand-new homepage design, plus support for JupyterLab, PGWeb, PEV2, PgBadger, and other useful tools. Brand New Homepage The Home Dashboard in Grafana has long served as …
The WeChat Photo Album Access Issue

Original WeChat Official Account Article Last night, I saw news about WeChat accessing user photo albums in the background, and WeChat responded: While such shady behavior from Chinese apps doesn’t surprise me, in the spirit of seeking truth, I got …
Original WeChat Official Account Article Last night, I saw news about WeChat accessing user photo albums in the background, and WeChat responded: While such shady behavior from Chinese apps doesn’t surprise me, in the spirit of seeking truth, I got …
Life at 28

Life at 28 Another Mid-Autumn Festival, another year older. My solar birthday (September 21st) coinciding with Mid-Autumn Festival should only happen three times in my lifetime: once at age 9 in 2002, once at age 28 in 2021, and the last time at age …
Life at 28 Another Mid-Autumn Festival, another year older. My solar birthday (September 21st) coinciding with Mid-Autumn Festival should only happen three times in my lifetime: once at age 9 in 2002, once at age 28 in 2021, and the last time at age …
Pigsty v1.0: GA Release with Monitoring Overhaul

GitHub Release | Release Note After over a year of iterations and refinement, Pigsty officially ships v1.0.0 GA. Pigsty (/ˈpɪɡˌstaɪ/) stands for PostgreSQL In Graphic STYle — PostgreSQL, visualized. What is Pigsty? Pigsty is a batteries-included …
GitHub Release | Release Note After over a year of iterations and refinement, Pigsty officially ships v1.0.0 GA. Pigsty (/ˈpɪɡˌstaɪ/) stands for PostgreSQL In Graphic STYle — PostgreSQL, visualized. What is Pigsty? Pigsty is a batteries-included …
On the Hills of Manchuria

The Dragon Boat Festival holiday coincided with college entrance exams. Not wanting to see crowds everywhere, I discussed with two colleagues and decided to find a weekend for early off-peak travel. We settled on Hulunbuir - Friday night flight from …
The Dragon Boat Festival holiday coincided with college entrance exams. Not wanting to see crowds everywhere, I discussed with two colleagues and decided to find a weekend for early off-peak travel. We settled on Hulunbuir - Friday night flight from …
Ready-to-Use PostgreSQL Distribution: Pigsty

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. For example, Linux is an operating …
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. For example, Linux is an operating …
Why Does PostgreSQL Have a Bright Future?

Recently, everything I’ve been working on revolves around the PostgreSQL ecosystem, because I’ve always felt this is a direction with unlimited potential. Why do I say this? Because databases are the core component of information systems, relational …
Recently, everything I’ve been working on revolves around the PostgreSQL ecosystem, because I’ve always felt this is a direction with unlimited potential. Why do I say this? Because databases are the core component of information systems, relational …
Pigsty v0.9: CLI + Logs

GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.9.0 New Stuff One-liner install: curl -fsSL https://pigsty.cc/install | bash bootstraps everything. pigsty-cli: wraps the common Ansible playbooks so you stop copy-pasting command …
GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.9.0 New Stuff One-liner install: curl -fsSL https://pigsty.cc/install | bash bootstraps everything. pigsty-cli: wraps the common Ansible playbooks so you stop copy-pasting command …
Pigsty v0.8: Service Provisioning

GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.8.0 v0.8 finalizes the provisioning API. Services are completely rebuilt: instead of a hard-coded primary/replica pair you can now declare any number of services, plug in HAProxy, swap …
GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.8.0 v0.8 finalizes the provisioning API. Services are completely rebuilt: instead of a hard-coded primary/replica pair you can now declare any number of services, plug in HAProxy, swap …
Localization and Collation Rules in PostgreSQL

Why does Pigsty default to locale=C and encoding=UTF8 when initializing PostgreSQL databases? The answer is simple: Unless you explicitly know you need LOCALE-related functionality, you should never configure anything other than C.UTF8 for character …
Why does Pigsty default to locale=C and encoding=UTF8 when initializing PostgreSQL databases? The answer is simple: Unless you explicitly know you need LOCALE-related functionality, you should never configure anything other than C.UTF8 for character …
Implementing Advanced Fuzzy Search

In daily development, we often encounter requirements for fuzzy search. Today, let’s briefly discuss how to implement some advanced fuzzy search using PostgreSQL. Of course, the fuzzy search I’m talking about here isn’t the old-fashioned LIKE …
In daily development, we often encounter requirements for fuzzy search. Today, let’s briefly discuss how to implement some advanced fuzzy search using PostgreSQL. Of course, the fuzzy search I’m talking about here isn’t the old-fashioned LIKE …
PostgreSQL Logical Replication Deep Dive

Logical Replication Logical Replication is a method of replicating data objects and their changes based on their replica identity (usually the primary key). The term logical replication contrasts with physical replication. Physical replication uses …
Logical Replication Logical Replication is a method of replicating data objects and their changes based on their replica identity (usually the primary key). The term logical replication contrasts with physical replication. Physical replication uses …
PG Replica Identity Explained

Introduction: DIY Logical Replication The concept of replica identity serves logical replication. The basic working principle of logical replication is to decode row-level INSERT/UPDATE/DELETE events from logical publication-related tables and …
Introduction: DIY Logical Replication The concept of replica identity serves logical replication. The basic working principle of logical replication is to decode row-level INSERT/UPDATE/DELETE events from logical publication-related tables and …
