Open-access PostgreSQL training curriculum by French consultancy Dalibo, spanning core DBA operations, Patroni HA, performance tuning, and CloudNativePG:
Open-Source Footprint
Biography
Who I am, and what I work on
I am Ruohang Feng, widely known online as Vonng. Since 2015 I have focused on PostgreSQL and data infrastructure — building database tooling, running large-scale clusters, and writing extensively about databases and cloud economics.
In 2018 I created Pigsty (PostgreSQL In Great STYle) — a battery-included, local-first open-source PostgreSQL RDS distribution. It integrates high availability (Patroni), point-in-time recovery (pgBackRest), connection pooling (PgBouncer), observability (pg_exporter + Grafana/VictoriaMetrics), and the pgext.cloud supply chain (2,200+ cataloged extensions and 570+ pre-built binary packages across 16 Linux distros) into a self-hosted RDS that gives anyone cloud-grade database capability on bare metal without paying the cloud premium.
Before founding pgsty.com to work on open-source infrastructure full-time, I served as a software engineer, lead DBA, and infrastructure architect at Alibaba, TanTan, and Apple, where I designed and operated hundreds of production PostgreSQL clusters.
Outside of engineering, I translated Designing Data-Intensive Applications (DDIA), Internals of PostgreSQL, PostgreSQL 18 Internals, PostgreSQL Monitoring, and PostgreSQL 18 Query Optimization into Chinese; maintain the pg.center knowledge graph and pgsql.cc documentation portal; and write for a combined readership of ~100,000 engineers. For a structured record of my ecosystem work, see my PostgreSQL Contributor Dossier.
Away from the terminal, I hike, travel, study comparative religion and philosophy, and play strategy games — documented in Cyber Dharma, Travel Notes, and Miscellaneous.
Open Source
Nine open-source projects across PostgreSQL RDS, S3 object storage, package management, local VMs, and developer ergonomics.
Pigsty
A battery-included PostgreSQL distribution — the local-first, free and open-source RDS alternative.
SILO
The community-maintained MinIO fork that keeps high-performance S3-compatible object storage genuinely open source.
OINK
A local-first, zero-external-dependency Hugo theme for engineering documentation, books, and technical blogs.
PIG
One command, any PostgreSQL extension — native RPM and DEB package management across EL, Debian, and Ubuntu.
SOW
Store once, serve everywhere — one self-contained binary for building, snapshotting, and publishing APT and YUM repos.
pg_exporter
PostgreSQL observability expressed in SQL — 600+ metrics via declarative YAML collectors for Prometheus.
Barn
Boot multi-node Linux labs from a single YAML inventory, or run isolated native macOS VMs on Apple Silicon.
Capslock
Turn the forgotten CapsLock key into a fifth modifier (Hyper) for sixteen home-row keyboard control planes.
ACDAT
Zero-dependency C11 PostgreSQL extension compiling large literal pattern sets into a Double-Array Trie for O(n) scanning.Works
Original monographs on production PostgreSQL and comparative philosophy, alongside research papers on LLM-powered database diagnosis and heterogeneous data federation.
36 Stratagems of PostgreSQL
From SQL to Production: a 36-chapter, 242-section engineering monograph built on PostgreSQL 18.6 and Pigsty 4.5 with reproducible labs.
Cyber Dharma (赛博经藏)
Seven ancient contemplative traditions orbiting one modern machine — a bilingual canon translating timeless wisdom into AI Agent governance.
D-Bot: Database Diagnosis System using Large Language Models
Co-authored with the Tsinghua University database group (VLDB 2024): collaborative LLM agents with tool use and knowledge retrieval for automated root-cause diagnosis.
Unified Access Layer with PostgreSQL FDW for Heterogeneous Databases
Published at IFIP NPC 2017 (Springer LNCS Vol. 10578): federating HBase, Redis, MongoDB, and MySQL behind a unified SQL interface via PostgreSQL Foreign Data Wrappers.Translations
Chinese translations of distributed systems and PostgreSQL classics, tutorials, and official training curricula.
DDIA
Chinese translation of Martin Kleppmann’s Designing Data-Intensive Applications (2nd Edition) — the distributed systems classic.
Internals of PostgreSQL
Chinese edition of Hironobu Suzuki’s classic guide to PostgreSQL storage layout, query execution, MVCC, and WAL.
PostgreSQL 18 Internals
Chinese edition of Egor Rogov’s comprehensive volume on PostgreSQL 18 concurrency, buffer management, locks, and access methods.
PostgreSQL Monitoring
Chinese edition of Alexey Lesovsky’s handbook on PostgreSQL statistics views, I/O telemetry, lock analysis, and OS profiling.
PostgreSQL 18 Query Optimization
Chinese edition of Pavel Tolmachev’s query optimization handbook covering access methods, join strategies, statistics, and tuning.
PostgreSQL New Features
Chinese edition of Noriyoshi Shinoda’s guide to new features, SQL examples, and compatibility changes across 12 major PG releases.
PostgreSQL: First Experience
Chinese edition of Pavel Luzanov et al.’s beginner guide — from installing PostgreSQL and writing SQL to connecting applications.
PostgreSQL by Example
Chinese edition of Dariush Abbasi’s Postgres by Example — 57 concise, runnable SQL lessons from queries to administration.
PostgreSQL Basics (8KB)
Chinese edition of Chase Pierce’s Eight Kilobytes — understanding PostgreSQL from 8 KB disk pages and tuples to production ops.Eight structured training courses from Postgres Professional (134 topics and 5,300+ slide/workbook pages) covering administration, security, and backend development:
Sites
Core PostgreSQL knowledge portals, extension catalogs, and open-source project websites.
pg.center
Connected PostgreSQL manuals, GUC parameters, system catalogs, and 500+ extension references across versions.
pgsql.cc
Chinese PostgreSQL community portal with synchronized manuals, daily news, version comparisons, books, and tutorials.
pgext.cloud
An index, catalog, and metadata registry for 2,200+ PostgreSQL extensions, with binary packages and build matrices for 570+ of them.
vonng.com
Ruohang Feng’s personal website and long-form engineering columns on databases, cloud repatriation, PostgreSQL internals, and AI agents.
pigsty
Official documentation and portal for Pigsty — the battery-included, local-first open-source PostgreSQL RDS distribution.
pgsty.com
The studio behind Pigsty, delivering open-source PostgreSQL infrastructure, enterprise subscriptions, and consulting services.