PostgreSQL Mage
Ruohang Feng @Vonng / Pigsty
PostgreSQL ecosystem news, plus development, operations, internals and tuning.
PostgreSQL Ecosystem Update: The AI Bug-Hunting Crunch
AI-driven vulnerability discovery has open-source maintainers scrambling to ship patches, delaying PostgreSQL 19 and triggering a wave of extension releases. This post covers OrioleDB 1.10.1, DuckDB …
Taking Over Another PostgreSQL Extension: vchord Yesterday, pg_mooncake Today
A day after taking over VectorChord, I forked pg_mooncake—restoring its documentation and blog from the Internet Archive, updating it for pg_duckdb 1.2 and pgrx 0.19.3, and shipping packages for …
Why I'm Maintaining a VectorChord Fork
Why I forked TensorChord's VectorChord (vchord), vchord_bm25, and pg_tokenizer under pgsty—what our pre-release audit uncovered, what we fixed in vchord 1.2.0, and what it takes to keep an open-source …
Reviving the Chinese-Speaking PostgreSQL Community
A PostgreSQL community starts with its users. With a distribution, documentation, package mirrors, localized messages, and a Chinese-language portal now in place, the next step is connecting them into …
Why Localize PostgreSQL into Chinese?
Both Simplified and Traditional Chinese message catalogs in PostgreSQL 19 now meet the release threshold across all 28 components. Chinese localization lowers reading overhead during production …
PostgreSQL 19 Beta 4: Five Major Features Reverted
PostgreSQL 19 Beta 4 reverted five major features at once: SQL/PGQ property graph queries, online data checksums, temporal UPDATE and DELETE, partition merge and split, and DDL reconstruction …
PostgreSQL's Chinese Translations Went Seven Years Untended. I Fixed Them in Seven Days.
Never set your PostgreSQL locale to zh_CN: that old rule expires with PostgreSQL 19. After seven years of neglect nearly cost Chinese its place in the release, I rebuilt the message catalogs in seven …
Chinese PostgreSQL Docs Are Live: All 11 Major Versions
pgsql.cc is live, with Chinese documentation for all 11 PostgreSQL major versions from 10 through 20, a redesigned mirror of the official website, and better full-text search. Kept in sync with …
Happy 30th Birthday, PostgreSQL
On July 8, 1996, the PostgreSQL community picked up the flame from Postgres95. Thirty years later, it has grown from a Berkeley research project into a default foundation of the global database …
Instantly Clone PostgreSQL Databases—No Black Magic Required
Pig v1.5 adds pig pg clone and pig pg fork, wrapping PostgreSQL 18's instant cloning capabilities in an agent-native CLI.
What Is a PostgreSQL Distribution?
Starting with Linux distributions, this essay explains what a “PostgreSQL distribution” actually is: three layers, two paths, and one core idea.
PostgreSQL Turns 30
I joined a 90-minute livestream today for PostgreSQL's 30th anniversary. Since most people don't have time to sit through a full stream, I turned my remarks and reflections into this essay.
Attending PGConf.dev 2026: PostgreSQL's 30th Anniversary Developer Conference
Day-one notes from PGConf.dev 2026 in Vancouver: delivering "Extensions for Everyone," meeting PostgreSQL pioneer Jolly Chen, and catching up with the global Postgres community on its 30th …
Extensions for Everyone
A field report on the PostgreSQL extension ecosystem: 1,617 discovered projects, 511 deliverable extensions, and the shared delivery layer needed to make extensibility work for users, authors, …
PGConf.Dev 2026 Opens Today in Vancouver
PGConf.Dev 2026 opens in Vancouver as the PostgreSQL project marks its 30th anniversary. I will also be speaking on Extensions for Everyone.
The pgBackRest Rescue and Open Source's Forced Price Discovery
Seven days after pgBackRest was archived, David Steele said a coalition of sponsors was nearly in place and the project would probably live on. This was not just a heartwarming community story. It was …
pgBackRest is No Longer Maintained
Its maintainer, under pressure to make a living, has formally archived pgBackRest, the PostgreSQL ecosystem's most important backup tool. The entire PostgreSQL community needs to think seriously about …
504 Extensions: Expand the PostgreSQL Landscape
One GitHub issue turned into an extension sprint. 32 new additions, 504 in total, say a lot about where PostgreSQL is headed.
PostgreSQL vs. MySQL in 2026
By 2026, PostgreSQL has won the market for new database adoption, outperforming MySQL across developer adoption, vendor strategy, capital markets, and community governance. MySQL still owns the …
Chinese Docs for Five PostgreSQL Versions Are Now Live
PG.center now provides Chinese documentation for PostgreSQL 18, 17, 16, 15, and 14, covering every major version still in active support.
pg.center: A Chinese Mirror of the PostgreSQL Website
pg.center is a full Chinese mirror of postgresql.org, including the homepage, docs, news, community pages, and developer resources, plus a newly translated PostgreSQL 18 manual.
464 PostgreSQL Extensions Out of the Box: Launching the New PG Extension Catalog
With help from Claude Code, I built a brand-new PostgreSQL extension catalog covering 464 extensions—complete with embedded documentation and agent-friendly Markdown—now live at https://pigsty.cc/ext. …
PostgreSQL Out-of-Cycle Emergency Minor Releases Are Out
As noted in last week's advisory on the February minor-release regressions, it was worth holding off on upgrades until the out-of-cycle fixes shipped. Those emergency releases (PostgreSQL 18.3, 17.9, …
Is Oracle-Compatible Postgres Actually Useful?
A migration case with only a JAR and no source code shows why Oracle syntax compatibility is not always a fake requirement, and how IvorySQL + Pigsty can absorb legacy debt at low cost.
PostgreSQL Ecosystem Update: The AI Bug-Hunting Crunch
AI-driven vulnerability discovery has open-source maintainers scrambling to ship patches, delaying PostgreSQL 19 and triggering a wave of extension releases. This post covers OrioleDB 1.10.1, DuckDB …
Taking Over Another PostgreSQL Extension: vchord Yesterday, pg_mooncake Today
A day after taking over VectorChord, I forked pg_mooncake—restoring its documentation and blog from the Internet Archive, updating it for pg_duckdb 1.2 and pgrx 0.19.3, and shipping packages for …
Why I'm Maintaining a VectorChord Fork
Why I forked TensorChord's VectorChord (vchord), vchord_bm25, and pg_tokenizer under pgsty—what our pre-release audit uncovered, what we fixed in vchord 1.2.0, and what it takes to keep an open-source …
Reviving the Chinese-Speaking PostgreSQL Community
A PostgreSQL community starts with its users. With a distribution, documentation, package mirrors, localized messages, and a Chinese-language portal now in place, the next step is connecting them into …
Why Localize PostgreSQL into Chinese?
Both Simplified and Traditional Chinese message catalogs in PostgreSQL 19 now meet the release threshold across all 28 components. Chinese localization lowers reading overhead during production …
PostgreSQL 19 Beta 4: Five Major Features Reverted
PostgreSQL 19 Beta 4 reverted five major features at once: SQL/PGQ property graph queries, online data checksums, temporal UPDATE and DELETE, partition merge and split, and DDL reconstruction …
PostgreSQL's Chinese Translations Went Seven Years Untended. I Fixed Them in Seven Days.
Never set your PostgreSQL locale to zh_CN: that old rule expires with PostgreSQL 19. After seven years of neglect nearly cost Chinese its place in the release, I rebuilt the message catalogs in seven …
Chinese PostgreSQL Docs Are Live: All 11 Major Versions
pgsql.cc is live, with Chinese documentation for all 11 PostgreSQL major versions from 10 through 20, a redesigned mirror of the official website, and better full-text search. Kept in sync with …
Happy 30th Birthday, PostgreSQL
On July 8, 1996, the PostgreSQL community picked up the flame from Postgres95. Thirty years later, it has grown from a Berkeley research project into a default foundation of the global database …
Instantly Clone PostgreSQL Databases—No Black Magic Required
Pig v1.5 adds pig pg clone and pig pg fork, wrapping PostgreSQL 18's instant cloning capabilities in an agent-native CLI.
What Is a PostgreSQL Distribution?
Starting with Linux distributions, this essay explains what a “PostgreSQL distribution” actually is: three layers, two paths, and one core idea.
PostgreSQL Turns 30
I joined a 90-minute livestream today for PostgreSQL's 30th anniversary. Since most people don't have time to sit through a full stream, I turned my remarks and reflections into this essay.
Attending PGConf.dev 2026: PostgreSQL's 30th Anniversary Developer Conference
Day-one notes from PGConf.dev 2026 in Vancouver: delivering "Extensions for Everyone," meeting PostgreSQL pioneer Jolly Chen, and catching up with the global Postgres community on its 30th …
Extensions for Everyone
A field report on the PostgreSQL extension ecosystem: 1,617 discovered projects, 511 deliverable extensions, and the shared delivery layer needed to make extensibility work for users, authors, …
PGConf.Dev 2026 Opens Today in Vancouver
PGConf.Dev 2026 opens in Vancouver as the PostgreSQL project marks its 30th anniversary. I will also be speaking on Extensions for Everyone.
The pgBackRest Rescue and Open Source's Forced Price Discovery
Seven days after pgBackRest was archived, David Steele said a coalition of sponsors was nearly in place and the project would probably live on. This was not just a heartwarming community story. It was …
pgBackRest is No Longer Maintained
Its maintainer, under pressure to make a living, has formally archived pgBackRest, the PostgreSQL ecosystem's most important backup tool. The entire PostgreSQL community needs to think seriously about …
504 Extensions: Expand the PostgreSQL Landscape
One GitHub issue turned into an extension sprint. 32 new additions, 504 in total, say a lot about where PostgreSQL is headed.
PostgreSQL vs. MySQL in 2026
By 2026, PostgreSQL has won the market for new database adoption, outperforming MySQL across developer adoption, vendor strategy, capital markets, and community governance. MySQL still owns the …
Chinese Docs for Five PostgreSQL Versions Are Now Live
PG.center now provides Chinese documentation for PostgreSQL 18, 17, 16, 15, and 14, covering every major version still in active support.
pg.center: A Chinese Mirror of the PostgreSQL Website
pg.center is a full Chinese mirror of postgresql.org, including the homepage, docs, news, community pages, and developer resources, plus a newly translated PostgreSQL 18 manual.
464 PostgreSQL Extensions Out of the Box: Launching the New PG Extension Catalog
With help from Claude Code, I built a brand-new PostgreSQL extension catalog covering 464 extensions—complete with embedded documentation and agent-friendly Markdown—now live at https://pigsty.cc/ext. …
PostgreSQL Out-of-Cycle Emergency Minor Releases Are Out
As noted in last week's advisory on the February minor-release regressions, it was worth holding off on upgrades until the out-of-cycle fixes shipped. Those emergency releases (PostgreSQL 18.3, 17.9, …
Is Oracle-Compatible Postgres Actually Useful?
A migration case with only a JAR and no source code shows why Oracle syntax compatibility is not always a fake requirement, and how IvorySQL + Pigsty can absorb legacy debt at low cost.
PostgreSQL Ecosystem Update: The AI Bug-Hunting Crunch
In two recent posts—When the Cloud Gets Riddled with Holes and The Internet Is Getting Shot Full of Holes—I wrote about an uncomfortable reality: the entire software industry is going through an AI-driven security stress test. With AI-assisted …
In two recent posts—When the Cloud Gets Riddled with Holes and The Internet Is Getting Shot Full of Holes—I wrote about an uncomfortable reality: the entire software industry is going through an AI-driven security stress test. With AI-assisted …
Taking Over Another PostgreSQL Extension: vchord Yesterday, pg_mooncake Today
Originally published on WeChat Here we go again with another orphaned open-source project. Yesterday I wrote about how I spent a day taking over the vchord vector search extension. Barely a day later, I ended up taking on another PostgreSQL …
Originally published on WeChat Here we go again with another orphaned open-source project. Yesterday I wrote about how I spent a day taking over the vchord vector search extension. Barely a day later, I ended up taking on another PostgreSQL …
Why I'm Maintaining a VectorChord Fork
I am now maintaining forks of VectorChord (vchord)—one of the best-known vector search extensions in the PostgreSQL ecosystem—and its companion extensions, vchord_bm25 and pg_tokenizer, under the pgsty GitHub organization. When active upstream …
I am now maintaining forks of VectorChord (vchord)—one of the best-known vector search extensions in the PostgreSQL ecosystem—and its companion extensions, vchord_bm25 and pg_tokenizer, under the pgsty GitHub organization. When active upstream …
Reviving the Chinese-Speaking PostgreSQL Community
PostgreSQL is the world’s most advanced open-source database, and one of the very few major open-source projects genuinely run by its community rather than controlled by a single company. I have always believed that the soul of an open-source project …
PostgreSQL is the world’s most advanced open-source database, and one of the very few major open-source projects genuinely run by its community rather than controlled by a single company. I have always believed that the soul of an open-source project …
Why Localize PostgreSQL into Chinese?
The PostgreSQL 19 release schedule is set: RC1 lands next Thursday, October 15, and barring surprises, the final release follows on October 29. Good news for Chinese-speaking users along with it: following Simplified Chinese, Traditional Chinese …
The PostgreSQL 19 release schedule is set: RC1 lands next Thursday, October 15, and barring surprises, the final release follows on October 29. Good news for Chinese-speaking users along with it: following Simplified Chinese, Traditional Chinese …
PostgreSQL 19 Beta 4: Five Major Features Reverted
Original WeChat post (in Chinese) Today is the Mid-Autumn Festival, a holiday traditionally about reunion. Happy holidays to everyone celebrating. The news for the occasion, though, is less about things coming together than getting pulled apart: …
Original WeChat post (in Chinese) Today is the Mid-Autumn Festival, a holiday traditionally about reunion. Happy holidays to everyone celebrating. The news for the occasion, though, is less about things coming together than getting pulled apart: …
PostgreSQL's Chinese Translations Went Seven Years Untended. I Fixed Them in Seven Days.
If you have used PostgreSQL for any length of time in China, you have probably heard the unwritten rule: when you install the database, do not set the message locale (lc_messages) to zh_CN (Simplified Chinese). Use en_US and be done with it. The rule …
If you have used PostgreSQL for any length of time in China, you have probably heard the unwritten rule: when you install the database, do not set the message locale (lc_messages) to zh_CN (Simplified Chinese). Use en_US and be done with it. The rule …
Chinese PostgreSQL Docs Are Live: All 11 Major Versions
pgsql.cc launches today, with Chinese documentation for 11 PostgreSQL major versions, a redesigned mirror of the official website, and better full-text search. It finally fills the documentation gap in the Chinese PostgreSQL ecosystem. It goes beyond …
pgsql.cc launches today, with Chinese documentation for 11 PostgreSQL major versions, a redesigned mirror of the official website, and better full-text search. It finally fills the documentation gap in the Chinese PostgreSQL ecosystem. It goes beyond …
Happy 30th Birthday, PostgreSQL
Today, July 8, 2026, is PostgreSQL’s 30th birthday. Thirty years ago, Marc Fournier made a commit named “Postgres95 1.01 Distribution - Virgin Sources” into a newly created CVS repository. It was the first commit in the PostgreSQL codebase (d31084e), …
Today, July 8, 2026, is PostgreSQL’s 30th birthday. Thirty years ago, Marc Fournier made a commit named “Postgres95 1.01 Distribution - Virgin Sources” into a newly created CVS repository. It was the first commit in the PostgreSQL codebase (d31084e), …
Instantly Clone PostgreSQL Databases—No Black Magic Required
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 copy-on-write (CoW) and PostgreSQL 18’s …
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 copy-on-write (CoW) and PostgreSQL 18’s …
What Is a PostgreSQL Distribution?
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 is not databases, but operating …
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 is not databases, but operating …
PostgreSQL Turns 30
I joined a 90-minute livestream today for PostgreSQL’s 30th anniversary. Since most people don’t have time to sit through a full stream, I turned my remarks and reflections into this essay. 1. How Do We Count to Thirty? First, a historical footnote: …
I joined a 90-minute livestream today for PostgreSQL’s 30th anniversary. Since most people don’t have time to sit through a full stream, I turned my remarks and reflections into this essay. 1. How Do We Count to Thirty? First, a historical footnote: …
Attending PGConf.dev 2026: PostgreSQL's 30th Anniversary Developer Conference
The original WeChat post is no longer available; the text below was recovered from an attributed public mirror: https://www.163.com/dy/article/KTG7NBBQ0556CSY5.html. Today is the opening day of PGConf.dev 2026. I gave a 25-minute talk, Extensions …
The original WeChat post is no longer available; the text below was recovered from an attributed public mirror: https://www.163.com/dy/article/KTG7NBBQ0556CSY5.html. Today is the opening day of PGConf.dev 2026. I gave a 25-minute talk, Extensions …
Extensions for Everyone
Slide deck: Extensions for Everyone Part I. Introduction 0. Extensions for Everyone 00. Extensions for Everyone Hi everyone. This talk is called Extensions for Everyone. It is about delivering PostgreSQL extensions, and about how a shared delivery …
Slide deck: Extensions for Everyone Part I. Introduction 0. Extensions for Everyone 00. Extensions for Everyone Hi everyone. This talk is called Extensions for Everyone. It is about delivering PostgreSQL extensions, and about how a shared delivery …
PGConf.Dev 2026 Opens Today in Vancouver
On May 19, Vancouver time, PGConf.Dev 2026 officially gets underway. This year’s venue is Simon Fraser University’s downtown campus, SFU Vancouver Harbour Centre. The conference has returned to Vancouver, host city of the inaugural PGConf.Dev. …
On May 19, Vancouver time, PGConf.Dev 2026 officially gets underway. This year’s venue is Simon Fraser University’s downtown campus, SFU Vancouver Harbour Centre. The conference has returned to Vancouver, host city of the inaugural PGConf.Dev. …
The pgBackRest Rescue and Open Source's Forced Price Discovery
A few days ago, pgBackRest, the PostgreSQL ecosystem’s leading open-source backup tool, was archived. Pigsty uses pgBackRest too, but I was not especially worried. A component this important was never going to be allowed to die for real—not by the …
A few days ago, pgBackRest, the PostgreSQL ecosystem’s leading open-source backup tool, was archived. Pigsty uses pgBackRest too, but I was not especially worried. A component this important was never going to be allowed to die for real—not by the …
pgBackRest is No Longer Maintained
On April 27, David Steele formally archived pgBackRest, the most important backup tool in the PostgreSQL ecosystem. The announcement appeared on GitHub and LinkedIn. It was brief and direct: The End-of-Maintenance Announcement TL;DR: pgBackRest is no …
On April 27, David Steele formally archived pgBackRest, the most important backup tool in the PostgreSQL ecosystem. The announcement appeared on GitHub and LinkedIn. It was brief and direct: The End-of-Maintenance Announcement TL;DR: pgBackRest is no …
504 Extensions: Expand the PostgreSQL Landscape
A GitHub issue turned into an extension sprint. 32 new additions say a lot about where PostgreSQL is headed. It Started with a Chemistry Extension Two days ago, a user opened a GitHub issue: he was using RDKit, the de facto standard library in …
A GitHub issue turned into an extension sprint. 32 new additions say a lot about where PostgreSQL is headed. It Started with a Chemistry Extension Two days ago, a user opened a GitHub issue: he was using RDKit, the de facto standard library in …
PostgreSQL vs. MySQL in 2026
PostgreSQL has won the market for new database deployments, and its installed base is now comparable to MySQL’s. With one rising and the other declining, there is little suspense left in the contest for the database kernel of the future. I. Developer …
PostgreSQL has won the market for new database deployments, and its installed base is now comparable to MySQL’s. With one rising and the other declining, there is little suspense left in the contest for the database kernel of the future. I. Developer …
Chinese Docs for Five PostgreSQL Versions Are Now Live
Yesterday I launched PG.center, a Chinese mirror of the PostgreSQL website. The response was immediate. There was one obvious gap, though: at launch, the site only had Chinese docs for PostgreSQL 18. Versions 17, 16, 15, and 14 are all still within …
Yesterday I launched PG.center, a Chinese mirror of the PostgreSQL website. The response was immediate. There was one obvious gap, though: at launch, the site only had Chinese docs for PostgreSQL 18. Versions 17, 16, 15, and 14 are all still within …
pg.center: A Chinese Mirror of the PostgreSQL Website
One thing has always bothered me after all these years using PostgreSQL:postgresql.org never had a Chinese edition. For English-speaking users, the official site is a one-stop hub for project information, release notes, documentation, community …
One thing has always bothered me after all these years using PostgreSQL:postgresql.org never had a Chinese edition. For English-speaking users, the official site is a one-stop hub for project information, release notes, documentation, community …
464 PostgreSQL Extensions Out of the Box: Launching the New PG Extension Catalog
Today I put Claude Code to work on another project: building a brand-new PostgreSQL extension catalog, now live at https://pigsty.cc/ext. This is actually the fifth iteration of the catalog. After coming full circle through several web frameworks, it …
Today I put Claude Code to work on another project: building a brand-new PostgreSQL extension catalog, now live at https://pigsty.cc/ext. This is actually the fifth iteration of the catalog. After coming full circle through several web frameworks, it …
PostgreSQL Out-of-Cycle Emergency Minor Releases Are Out
As I noted earlier in Urgent Advisory: Pause PostgreSQL Minor-Release Installs and Upgrades, the previous batch of PostgreSQL minor releases shipped with regressions, making it wiser to hold off on deployments until the out-of-cycle fixes arrived. …
As I noted earlier in Urgent Advisory: Pause PostgreSQL Minor-Release Installs and Upgrades, the previous batch of PostgreSQL minor releases shipped with regressions, making it wiser to hold off on deployments until the out-of-cycle fixes arrived. …
Is Oracle-Compatible Postgres Actually Useful?
I used to roll my eyes at “Oracle compatibility” in PostgreSQL forks. My take was simple: if your SQL doesn’t run on vanilla Postgres, fix your app rather than database. Then a migration task slightly changed my mind. The Problem: A JAR and Nothing …
I used to roll my eyes at “Oracle compatibility” in PostgreSQL forks. My take was simple: if your SQL doesn’t run on vanilla Postgres, fix your app rather than database. Then a migration task slightly changed my mind. The Problem: A JAR and Nothing …