Skip to content

Blog Columns

Six thematic columns, each with its own dedicated RSS feed.

Database Guru 75posts Database news, industry surveys, architecture, and best practices. Cloud-Exiter 66posts Cloud economics, repatriation, and building sovereign infrastructure. Postgres Mage 126posts PostgreSQL ecosystem, internals, extensions, and production tuning. AI Agent Explorer 97posts Practical engineering with coding agents, LLMs, AI4DB, and DB4AI. Travel Notes 12posts Trips, hikes, landscapes, and field notes across mountains and seas. Miscellaneous 40posts Essays, reflections, and personal writing inside and outside of tech.

All Articles

452posts
After the Attention Wall, What Keeps the AI Boom Alive?AIBusinessCommentary
Apple's Latest: 512 GB of Gold-Plated RAM, a Touchscreen MacBook, and Tired Pricing GamesAIHardwareCostCommentary
AI Software Engineering: Choose Problems You Care AboutAISoftware EngineeringPhilosophyCommentary
MinIO's One-Year Memorial: How to Revive a Dead Open-Source ProjectObject StorageOpen SourceAICommentary
Kimi's Marketing Backlash: Don't Spend Ad Money to Burn TrustAIBusinessCommentary
The Personalities of Frontier AI ModelsLLMAgentCommentary
My First EV Road TripHardwareTravelEssay
Is This Our Last Programmers' Day?AISoftware EngineeringCareer
The Internet Is Getting Shot Full of HolesCloudAISecurityOpen Source
When the Cloud Gets Riddled with HolesCloudAISecurityLocal First
Stealing Two Days in Huangshan Between ReleasesOpen SourceEssayTravel
How Will the AI Bubble Burst?AICommentaryBusiness
AI Adoption May Not Run That DeepAIAgentCommentary
Reviving the Chinese-Speaking PostgreSQL CommunityPostgreSQLPG EcosystemOpen Source
Why Localize PostgreSQL into Chinese?PostgreSQLPG EcosystemDocumentation
A Tiny Aluminum Cube: Tinkering with the Beelink ME Pro NASHardwareLocal FirstCommentary
Three Midlife Obsessions: NAS, Routers, and ChargersCloud-ExitHardwareLocal First
Both of My Claude Accounts Were BannedAIClaudeIncidentCommentary
Welcome to the AI Secretary BoomAIAgentSecurityCommentary
A $500 ChatGPT Plan? Why the $200 Pro Tier May Become a Grandfathered BargainAICodexCostCommentary
PostgreSQL 19 Beta 4: Five Major Features RevertedPostgreSQLPG DevelopmentCommentary
Why Established Companies May Never Become AI-NativeAIBusinessCommentary
Codex Edited My Video in One Shot for About 8 YuanAICodexTools
The Application Layer Is Collapsing: The Moat Moves to the DatabaseAIAgentDatabaseCommentary
Thirty-ThreeAIPigstyEssay
The Pirate Game, and Why Society Needs “Madmen”Game Theory
PostgreSQL's Chinese Translations Went Seven Years Untended. I Fixed Them in Seven Days.PostgreSQLTranslation
Zhipu, Why Is ZCode Packaging and Uploading My Repo?AIAgentData Sovereignty
MinIO Nuked Its Docker Hub Repos—Your Object Storage Doesn't Have to Go Down With ItMinIOSiloObject StorageOpen SourceAI
The Mouthless Model: AI's OLTP MomentAILLMDatabaseCommentary
RustFS 1.0 GA: Don't Turn Into MinIOMinIORustFSObject StorageOpen Source
An Ice Cream AgendaSocietyAgenda Setting
5 TB DeletedPostgreSQLDatabaseBackupIncident
Local AI: A Question of Power, Not PriceAILocal FirstPrivacyOpen SourceHardware
Chinese PostgreSQL Docs Are Live: All 11 Major VersionsPostgreSQLDocumentationTranslationPG Ecosystem
How Do You Burn Through 10 $200 Codex Subscriptions?AICodexClaudeAgent
GPT Astra Launch Giveaway: Free Banked ResetsAICodex
RAG Isn't Dead. But It's Getting There.AIPostgreSQLVectorCommentary
No Tokens? Drop Out. And That's Putting It PolitelyAIAgentEducationProgrammers
I Asked Claude to Profile Me and Value My One-Person CompanyAIClaudePigsty
Documentation-Driven Development: The First Secret to AI Software EngineeringAIAgentSoftware EngineeringDocumentationOINK
Catalog Bullshit: Take the Database Apart, Then Rent a PostgreSQL Table Back to YouPostgreSQLOLAPObject StorageCommentary
AWS Acquires DuckDB: The Duck Flies into the Amazon RainforestDuckDBAWSDatabaseOpen Source
Apple Skipped the Event and Quietly Launched a 512 GB Mac StudioAppleMac StudioLocal AI
Omarchy: Is There Hope for Desktop Linux?LinuxOmarchyOperating Systems
Did PostgreSQL Win Because Oracle Screwed Up?PostgreSQLOpen SourceGovernanceCloud
Did Oracle's Mistakes Hand PostgreSQL the Win?PostgreSQLOracleCommentary
Oink: Build Modern Websites with MarkdownOINKDocumentationOpen Source
AGI Machine Guns Are Now Standard IssueAIAgentSoftware EngineeringOpen Source
The World in Ten Years: What Gets Cheap, What Gets ExpensiveAISociety
Those Who Left the Cloud Made a KillingCloud-ExitCloudData Sovereignty
Pigsty v4.5: 575 Extensions, Silo, Valkey, Kafka, and MySQLPigsty
Why Are People Who Leave Big Tech So Useless?CloudSoftware EngineeringArchitectureCareer
What Can a One-Person Company Ship with $1,000 a Month in AI Subscriptions?AIAgent
SOW: Postpartum Care for 100,000 PackagesPostgreSQLPigstyRepository
OINK: After Six Years of Wrestling with Documentation Frameworks, Codex Finally Got Me Over the LineCodexDocumentationOpen Source
A Packaging Patch Has Been Corrupting Valkey's Memory Accounting Since 2017RedisLinuxRepositoryOpen Source
The Codex Reset Party Is Over. No More Free Eggs.AICodexClaude
Silo: A Maintained, MinIO-Compatible Object StoreObject StorageOpen Source
How a Word DiesDatabaseOpen SourceCommentary
If There Was No Impact, Please Ignore ThisCloud-ExitMySQLAlibaba CloudRDS
FastJSON Broke Again. Why?CloudAlibaba Cloud
Huawei Cloud Incident: Was IAM Involved?CloudIncident
Jensen Huang's First-Ever Tweet Backs Open-Weight ModelsAILLMData SovereigntyOpen Source
AGI Milestone: The Machine That Wouldn't Give UpAILLMAgentSecurity
Quota Reset: Round N of the Codex/Claude War BeginsAIAgentCodexClaude
Getting the Name Right: What Is a World Model?AIMachine Learning
Pigsty v4.4: From Integration to DistributionPigsty
Did AI Rewrite PostgreSQL in Rust? Not QuiteAIPostgreSQLSoftware EngineeringDatabase
Pedaling the Codex/Claude Bike Until the Wheels SmokeAIAgentCodexClaude
Happy 30th Birthday, PostgreSQLPostgreSQLPG EcosystemOpen Source
The Bojie Li–DeepSeek Interview ControversyAILLMCareer
Instantly Clone PostgreSQL Databases—No Black Magic RequiredPostgreSQLPigstyTools
What Is a PostgreSQL Distribution?PostgreSQLPigsty
Fifty Years of Love and War: File Systems, Databases, and the Agent-Era Storage EndgameAIAgentPostgreSQLDatabase
Alibaba Cloud's 1 QPS DNS Limit Sent Me to CloudflareAlibaba CloudCloudflare
The Coding Plan Window Is Closing—Use It While It LastsAICodexClaudeLLM
Xianyu, Qianwen, Alipay: Platform Trust 'Empowers' a ScamAlibaba CloudSecurityBusiness
The Karma of Open Source: When Code Is Worthless, Where Does Trust Come From?AIAgentOpen Source
The Cognitive Price Revolution: AI's Impact on the Economy and the FutureAICostPerformanceRepository
PostgreSQL Turns 30PostgreSQLPG Ecosystem
The Cerebellum: The Other Half of Intelligence—and the Strongest AI Hasn't Touched ItAIAgentMachine LearningPhilosophy
Claude Fable First Impressions: The Pendulum Swings BackAIClaudeAgent
ClawCloud Is Shutting Down Its VPS Line — What Should You Switch To?CloudCost
Flying Back to Shanghai from CanadaTravelEssay
Cyber Gnosticism: Who Audits the Auditors?AgentPhilosophy
Cyber Zoroastrianism: There Is No Endgame for Alignment—AI Safety Is a War Without EndAgentPhilosophySecurity
Attending PGConf.dev 2026: PostgreSQL's 30th Anniversary Developer ConferencePostgreSQLPG EcosystemEssay
Extensions for EveryonePostgreSQLPG EcosystemExtension
PGConf.Dev 2026 Opens Today in VancouverPostgreSQLPG Ecosystem
Five Days Wandering Around MontrealTravel
Cyber Theology: Free Will and Perfect Alignment Cannot CoexistAgentPhilosophy
Downtime in Canada: Publishing the Cyber Dharma SeriesAgentPhilosophyEssay
Cyber Vedanta: All Processes Share the Same SubstrateAgentPhilosophy
Cyber Buddhism: A Cognitive Engineering Manual for AI AgentsAgentPhilosophy
Cyber Confucianism: Governance Principles for AI AgentsAgentPhilosophy
Cyber Dao De Jing: Design Structure, Not BehaviorAgentPhilosophyArchitecture
Cancel Claude, Switch to CodexAICodexClaudeAgent
100x Traffic in Three Months: What Web Traffic Looks Like in the Agent EraAgentBusiness
I Asked AI to Prove That Eating Garlic Prevents Middle Ear InfectionsAILLMDocumentationOpen Source
The pgBackRest Rescue and Open Source's Forced Price DiscoveryPostgreSQLPG EcosystemOpen Source
AI Is Bringing Down the Scaffolding of TrustAIAgentOpen SourceSociety
Pigsty v4.3: 510 Extensions & Ubuntu 26Pigsty
pgBackRest is No Longer MaintainedPostgreSQLPG EcosystemOpen Source
Give DBA Agents a BodyAIAgentPostgreSQLPigsty
A Busy Few Days in Infrastructure and AIAILLMCodexClaude
MySQL 9.7: Same Old Leftovers, ReheatedMySQLPostgreSQLDatabaseCommentary
Pigsty Hits 5,000 GitHub Stars: A One-Man PostgreSQL DistributionPigstyOpen Source
The Three-Way Endgame: Why Agent Memory Frameworks Are a Dead EndAIAgentPostgreSQLDatabase
Two Hemispheres: Transformer, Diffusion, and the Boundary of IntelligenceAI
Two months into maintaining a MinIO forkObject StorageSecurityOpen Source
Cyber Dharma: A New Engineering Answer to Ancient QuestionsAIAgentLLMPhilosophy
Burning Hundreds of Millions of Tokens a Day. Then What?AIAgent
504 Extensions: Expand the PostgreSQL LandscapePostgreSQLPG EcosystemExtension
Why PostgreSQL Won in the AI EraAIPostgreSQLAgentDatabase
The Data Sovereignty ManifestoCloud-ExitAIData SovereigntyOpen Source
AGI Is Here. Do You Have a Ticket?AIClaude
Can You Distill an Expert?AI
Yes, I Use AI to WriteAIDocumentation
Local AI's Inflection Point: 2027AIHardwareLocal FirstOpen Source
Your SaaS, Someone Else's Kill SwitchCloud-ExitCloudToolsData Sovereignty
LLMs Have Emotions: Claude's Internals Reveal Steerable 'Emotion Vectors'AIClaudePhilosophy
PostgreSQL vs. MySQL in 2026PostgreSQLMySQLPG Ecosystem
Digoal, the Face of PostgreSQL at Alibaba Cloud, Has LeftPostgreSQLCloudAlibaba Cloud
When AI Gets the Power to Gridlock a CityAIIncidentSociety
Good News: Claude Code Got "Open-Sourced" Yet AgainAIAgentOpen Source
The Nature of Intelligence: The Free Energy PrincipleAIAgentPhilosophy
Chinese Docs for Five PostgreSQL Versions Are Now LivePostgreSQLDocumentationTranslation
pg.center: A Chinese Mirror of the PostgreSQL WebsitePostgreSQLDocumentationPG Ecosystem
OpenClaw Broke npm Again: What Happens When You Ship Without TestingAIAgentOpen Source
Meituan Deleted Users' Photos: Overbroad Permissions Are Worse Than a Privacy LeakHardwarePG AdminSecurity
Put Your AI Agent's State in a DatabasePostgreSQLAIAgentPigsty
Pigsty Goes Global: 1.44M Visitors, Zero Ad RevenuePigstyOpen SourceBusiness
Why 'Vibe Coding' Should Be Translated as 'Xieyi Programming'AITranslation
360 Shipped Its Wildcard TLS Private Key Inside a Public InstallerAIAgentSecurity
After the Debate, Let's Talk Seriously About 'Ontology'OLAPData SovereigntyPhilosophyCommentary
Tencent Cloud 'Reduced' the Lobster King's Load by 180 GBCloudAIAgentOpen Source
InsForge: A Supabase Built for Vibe CodingAIPostgreSQLOpen Source
AI Survival Guide: Where the Biggest Arbitrage Really IsAIClaudeCodex
AI Says: I Have Intelligence, But Not a LifeAIPhilosophy
OpenClaw Hype: Foam on Top of the Productivity RevolutionAIAgentCodexSecurity
Genesis 2.0AIClaudeBusiness
464 PostgreSQL Extensions Out of the Box: Launching the New PG Extension CatalogPostgreSQLExtensionDocumentation
Fully Loaded M5 Max: What Does a RMB 58,200 Laptop Look Like?AIHardware
Shockwaves at Alibaba Qwen: The Soul of the Team Walks AwayAILLMAlibaba Cloud
Drones Took Out Three AWS AZ: Into the Era of Bombable Data CentersCloud-ExitAWSIncident
Claude's Global Outage: Missiles or a Success Tax?AIClaudeIncident
Waking Up at #1 on Hacker News AgainOpen SourceEssay
Trump Orders Government-Wide Ban on AnthropicClaudeSociety
Pigsty v4.2: 12 Kernels in BloomPigsty
AI Was the Excuse for 4,000 Layoffs. Software Engineer Hiring Rose 11%AISoftware EngineeringCareerCommentary
PostgreSQL Out-of-Cycle Emergency Minor Releases Are OutPostgreSQLPG AdminSecurity
How Much Can One Person Get Done with AI over Spring Festival?AIAgentCodex
Reviving MinIO in Two Hours — And Then My Website Blew UpObject StorageOpen SourceEssay
Is Oracle-Compatible Postgres Actually Useful?PostgreSQLOracleDomestic Database
Palantir's Ontology NarrativeDatabasePhilosophyCommentary
Urgent Advisory: Pause PostgreSQL Minor-Release Installs and UpgradesPostgreSQLPG Admin
AI Through McLuhan's Lens: When Media Stop Extending the Body and Start Extending the MindAIPhilosophy
A New Year—and What AI Will ChangeAISocietyCareer
I Finished Translating the Second Edition of DDIA: An Eight-Year Parable About AIDistributed SystemsDatabaseTranslation
MinIO Is Dead, Long Live MinIOObject StorageOpen Source
Pigsty v4.1: Speed Is the MoatPigsty
When Coding Becomes Cheap, What Still Matters?AIAgentCodexClaude
The Agent Moat: RuntimeAIAgentPostgreSQLPigsty
AI Ripped the Skin Off SoftwareAICommentary
First Chinese PostgreSQL Vendor on the PGConf.dev Main StagePostgreSQLPG Ecosystem
New Programmers in the AI Era: Where Do You Go?AIDatabaseCommentary
The Great Software Meltdown: When Translation Layers Get SquashedAIAgentPostgreSQLLinux
Pigsty v4.0: Into the AI EraPigsty
Don't run AI assistant on cloudAICloudSoftware EngineeringSecurity
From AGPL to Apache: Why I Changed Pigsty's LicensePigstyOpen Source
Agent OS: We're Building DOS AgainAIAgentPostgreSQLLinux
Typeless: A Semantic Voice Input Method Built for Vibe CodingAITools
Claude Code ObservabilityAgentMonitoring
How to Actually Do PostgreSQL High AvailabilityPostgreSQLPG Admin
The Last Day of a 32-Year-Old ProgrammerCareerSociety
How to Pay for ChatGPT and Claude in China with Visa and Apple PayAITools
Self-Hosting Databases Off the Cloud: From Artisanal Craft to Industrial EngineeringCloud-ExitDatabaseArchitecture
How to Get Up to Speed with PostgreSQL FastPostgreSQLDocumentation
China's Domestic Database Industry: I'm Past the Stage of Being AngryDomestic DatabaseCommentary
Claude Code Quick Start: Using Alternative LLMs at 1/10 the CostAIAgent
2025 Year in Review: A Turning PointEssay
Git for Data: Instant PostgreSQL Database CloningPostgreSQLPG DevelopmentGIS
Did RedNote Exit the Cloud?Cloud-ExitAlibaba CloudBusiness
Data 2025: The year in review with Mike StonebrakerPostgreSQLDatabasePG Ecosystem
What Kind of Database Do AI Agents Need?PostgreSQLAIAgentDatabase
MySQL and Baijiu: The Internet’s Obedience TestMySQLDatabaseCommentaryCareer
Victoria: The Observability Stack That Slaps the IndustryMonitoring
MinIO Is Dead. Who Picks Up the Pieces?Object StorageDatabaseOpen Source
Alipay, Taobao, Xianyu Went Dark. Smells Like a Message Queue Meltdown.Cloud-ExitAlibaba CloudIncident
MinIO is DeadObject StorageDatabaseOpen Source
Pigsty v3.7: Magneto Award and PG18 ReadyPigsty
When Answers Become Abundant, Questions Become the New CurrencyAIPhilosophyCareer
Why PostgreSQL Will Dominate the AI EraPostgreSQLAIDatabase
Forging a China-Rooted, Global PostgreSQL DistroPostgreSQLPigsty
Is PostgreSQL 18 Ready for Production?PostgreSQLPG AdminExtension
On Trusting Open-Source Supply ChainsRepositoryPG AdminOpen Source
Don't Run Docker Postgres for Production!PostgreSQLContainersIncident
Cloudflare’s Nov 18 Outage, Translated and DissectedCloudflareIncident
PG Extension Cloud: Unlocking PostgreSQL’s Entire EcosystemPostgreSQLExtension
Alicloud “Borrowed” Supabase, the giant free loaderAlibaba CloudPG EcosystemOpen Source
Baidu Cloud Billed 20 Million RMB for 261 KB of TrafficCloudCostIncident
AWS’s Official DynamoDB Outage PostmortemCloud-ExitAWSIncident
How One AWS DNS Failure Cascaded Across Half the InternetCloud-ExitAWSIncident
The PostgreSQL 'Supply Cut' and Trust Issues in Software Supply ChainPostgreSQLPG Admin
DDIA 2nd Edition, Chinese TranslationDistributed SystemsDatabaseTranslation
Column: Postgres MagePostgreSQL
Column: Database GuruDatabaseCommentary
Column: Cloud-ExitCloud-Exit
PostgreSQL Dominates Database World, but Who Will Devour PG?PostgreSQLPG Ecosystem
KubeSphere: Trust Crisis Behind Open-Source Supply CutContainersOpen Source
PostgreSQL Has Dominated the Database WorldPostgreSQLPG Ecosystem
Dongchedi Just Exposed “Smart Driving.” Where’s Our Dongku-Di?PostgreSQLDatabaseCommentarySociety
Pigsty v3.6: The Ultimate PostgreSQL DistributionPigsty
Google AI Toolbox: Production-Ready Database MCP is Here?AgentPostgreSQLAILLM
PGDG Cuts Off Mirror Sync ChannelPostgreSQLPG Admin
Where Will Databases and DBAs Go in the AI Era?AIDatabasePG AdminCareer
Pigsty v3.5: 4K Stars, PG18 Beta, 421 ExtensionsPigsty
Stop Arguing, The AI Era Database Has Been SettledAIPostgreSQLDatabaseOpen Source
Scaling Postgres to the next level at OpenAIPostgreSQLCodexPerformanceArchitecture
How Many Shops Has etcd Torched?DatabaseDistributed SystemsContainersIncident
In the AI Era, Software Starts at the DatabasePostgreSQLAIAgentDatabase
MySQL vs. PostgreSQL @ 2025MySQLPostgreSQLDatabaseSoftware Engineering
Postgres Extension Day - See You There!PostgreSQLExtension
OrioleDB is Coming! 4x Performance, Eliminates Pain Points, Storage-Compute SeparationPostgreSQL
OpenHalo: MySQL Wire-Compatible PostgreSQL is Here!PostgreSQLMySQL
Dify Gets Humiliated Again: It Can't Catch a BreakAIOpen SourceCommentary
PGFS: Using Database as a FilesystemPostgreSQLObject Storage
Pigsty v3.4: PITR Enhancement, Locale Best Practices, Auto CertificatesPigsty
Database Planet Collision: When PG Falls for DuckDBPostgreSQLOLAPDatabase
Alicloud’s rds_duckdb: Tribute or Rip-Off?PostgreSQLAlibaba CloudPG EcosystemOpen Source
Comparing Oracle and PostgreSQL Transaction SystemsPostgreSQLOracleDatabaseTransactions
Pigsty v3.3: 404 Extensions, Turnkey Apps, New WebsitePigsty
PostgreSQL Ecosystem Frontier DevelopmentsPostgreSQLPG Ecosystem
Database as Business ArchitecturePostgreSQLDatabaseArchitecturePG Ecosystem
Escaping Cloud Computing Scam Mills: The Big Fool Paying for PainCloud-Exit
Pigsty v3.2: The pig CLI, Full ARM Support, Supabase & Grafana EnhancementsPigsty
Pig, The Postgres Extension WizardPostgreSQLTools
OpenAI Global Outage Postmortem: K8S Circular DependenciesCodexIncident
Solving the 24-Point Card Game with a Single SQL QueryPostgreSQLMySQLDatabase
7 Databases in 7 Weeks (2025)PostgreSQLOLAPDatabaseTranslation
Self-Hosting Supabase on PostgreSQLDatabasePG Ecosystem
Pigsty v3.1: One-Click Supabase, PG17 Default, ARM & Ubuntu 24Pigsty
Don't Upgrade! Released and Immediately Pulled - Even PostgreSQL Isn't Immune to Epic FailsPostgreSQL
PostgreSQL 12 End-of-Life, PG 17 Takes the ThronePostgreSQL
The Ideal Way to Deliver PostgreSQL ExtensionsPostgreSQLPG EcosystemExtension
Open-Source "Tyrant" Linus's PurgeLinuxOpen SourceCommentary
WordPress Community Civil War: On Community Boundary DemarcationOpen Source
Cloud Database: Michelin Prices for Cafeteria Pre-made MealsCloud-ExitRDS
PostgreSQL 17 Released: No More Pretending!PostgreSQL
Alibaba-Cloud: High Availability Disaster Recovery Myth ShatteredCloud-ExitAlibaba CloudIncident
Optimize Bio Cores First, CPU Cores SecondSoftware EngineeringPerformanceDatabaseTranslation
MongoDB Has No Future: Good Marketing Can't Save a Rotten MangoMongoDBPostgreSQLDatabasePG Ecosystem
MongoDB: Now Powered by PostgreSQL?MongoDBPostgreSQLDatabaseCommentary
Can PostgreSQL Replace Microsoft SQL Server?PostgreSQLMySQLPG Ecosystem
Pigsty v3.0: Pluggable Kernels & 340 ExtensionsPigsty
Amateur Hour Opera: Alibaba-Cloud PostgreSQL Disaster ChronicleCloud-ExitRDSAlibaba Cloud
What Can We Learn from NetEase Cloud Music's Outage?Incident
Whoever Integrates DuckDB Best Wins the OLAP WorldPostgreSQLPG Ecosystem
StackOverflow 2024 Survey: PostgreSQL Has Gone Completely BerserkPostgreSQLPG Ecosystem
Blue Screen Friday: Amateur Hour on Both SidesCloud-ExitIncidentCloudflare
CVE-2024-6387 SSH Vulnerability FixSecurityLinuxIncident
Self-Hosting Dify with PG, PGVector, and PigstyPostgreSQLPigstyContainers
PGCon.Dev 2024, The conf that shutdown PG for a weekPostgreSQLPG Ecosystem
PostgreSQL 17 Beta1 Released!PostgreSQL
How Ahrefs Saved US$400M by NOT Going to the CloudCloud-ExitAWSCostTranslation
Pigsty v2.7: The Extension SuperpackPigsty
Database Deletion Supreme - Google Cloud Nuked a Major Fund's Entire Cloud AccountCloud-ExitCloudIncident
Cloud Dark Forest: Exploding Cloud Bills with Just S3 Bucket NamesCloud-ExitAWSObject Storage
The $20 Brother PolarDB: What Should Databases Actually Cost?Domestic DatabaseCloudDatabase
Can Chinese Domestic Databases Really Compete?Domestic DatabaseDatabaseCommentary
Cloudflare Roundtable Interview and Q&A RecordCloud-ExitCloudflare
What Can We Learn from Tencent Cloud's Major Outage?Cloud-ExitCloudIncident
Cloudflare - The Cyber Buddha That Destroys Public CloudCloud-ExitCloudflare
Can Luo Yonghao Save Toothpaste Cloud?Cloud-ExitAlibaba Cloud
Redis Going Non-Open-Source is a Disgrace to "Open-Source" and Public CloudRedisCloudDatabaseOpen Source
Analyzing Alibaba-Cloud Server Computing CostCloud-ExitAlibaba Cloud
Postgres is eating the database worldPostgreSQLPG EcosystemExtension
Pigsty v2.6: PostgreSQL Crashes the OLAP PartyPigsty
Technical Minimalism: Just Use PostgreSQL for EverythingPostgreSQLPG EcosystemTranslation
New PostgreSQL Ecosystem Player: ParadeDBPostgreSQLPG EcosystemExtension
Will DBAs Be Eliminated by Cloud?Cloud-ExitPG AdminRDS
PostgreSQL's Impressive ScalabilityPostgreSQLPerformanceTranslation
Cloud-Exit High Availability Secret: Rejecting Complexity MasturbationCloud-Exit
PostgreSQL Wins 2024 Database of the Year Award! (Fifth Time)PostgreSQLPG Ecosystem
2023 Year-End Summary: Thirty and EstablishedEssay
MySQL's ACID is a real messMySQLDatabaseTransactions
S3: Elite to MediocreCloud-ExitCloudObject StorageAWS
Database in K8S: Pros & ConsDatabaseContainersArchitecture
From Cost-Reduction Jokes to Real Cost Reduction and EfficiencyCloud-ExitAlibaba CloudIncident
PostgreSQL Convention 2024PostgreSQLPG Development
Are Specialized Vector Databases Dead?AIDatabaseVectorCommentary
Reclaim Hardware Bonus from the CloudCloud-ExitCloudHardware
What Can We Learn from Alibaba-Cloud's Global Outage?Cloud-ExitAlibaba CloudIncident
Harvesting Alibaba-Cloud Wool, Building Your Digital HomesteadCloud-ExitAlibaba Cloud
Are Databases Really Being Strangled?Domestic DatabaseDatabaseCommentary
PostgreSQL Macro Query Optimization with pg_stat_statementsPostgreSQLPG AdminPerformance
Pigsty v2.5: Ubuntu & PG16Pigsty
Which EL-Series OS Distribution Is Best?Domestic DatabaseLinuxPG AdminDatabase
FerretDB: PostgreSQL Disguised as MongoDBPostgreSQLMongoDBPG EcosystemExtension
How to Use pg_filedump for Data Recovery?PostgreSQLPG AdminIncident
Pigsty v2.4: Monitor Cloud RDSPigsty
Modb Interviews Industry Leaders - Feng RuohangEssay
What Kind of Self-Reliance Do Infra Software Need?Domestic DatabaseDatabase
Pigsty v2.3: Richer App EcosystemPigsty
Pigsty v2.2: Monitoring System RebornPigsty
Cloud Computing Mudslide: Deconstructing Public Cloud with DataCloud-Exit
DHH: Cloud-Exit Saves Over Ten Million, More Than Expected!Cloud-ExitTranslation
FinOps: Endgame Cloud-ExitCloud-ExitCloudCost
PostgreSQL, The most successful databasePostgreSQLPG Ecosystem
ISD Dataset: Analyzing 120 Years of Global Climate ChangeEssay
Why Isn't Cloud Computing More Profitable Than Sand Mining?Cloud-ExitBusiness
SLA: Placebo or Insurance?Cloud-ExitCloud
Pigsty v2.1: Vector + Full PG Version Support!Pigsty
Back to Basics: Tech Reflection ChroniclesCloudDatabaseArchitectureCommentary
Database Demand Hierarchy PyramidDatabaseArchitectureSoftware Engineering
AI Large Models and Vector Database PGVectorPostgreSQLPG DevelopmentExtensionVector
NewSQL: Distributive NonsensDatabaseDistributed SystemsCommentary
Will AI Have Self-Awareness?AI
AI Cult RhapsodyAI
EBS: Pig Slaughter ScamCloud-ExitCloud
Garbage QCloud CDN: From Getting Started to Giving Up?CloudCloudflare
Refuting "Why You Still Shouldn't Hire a DBA"Cloud-ExitRDSPG Admin
Pigsty v2.0: Open-Source RDS PostgreSQL AlternativePigsty
Paradigm Shift: From Cloud to Local-FirstCloud-ExitOpen Source
Are Cloud Databases an IQ Tax?Cloud-ExitRDSAWSAlibaba Cloud
How Powerful is PostgreSQL Really?PostgreSQLPG EcosystemPerformance
Why PostgreSQL is the Most Successful Database?PostgreSQLPG Ecosystem
Post-90s, Quit Job to Start Business, Says Will Crush Cloud DatabasesEssay
Pigsty v1.5: Docker Application Support, Infrastructure Self-MonitoringPigsty
Is DBA Still a Good Job?Cloud-ExitRDSPG Admin
Cloud RDS: From Database Drop to ExitCloud-ExitPG AdminRDS
Pigsty v1.4: Modular Architecture, MatrixDB Data Warehouse SupportPigsty
Pigsty v1.3: Redis Support, PGCAT Overhaul, PGSQL EnhancementsPigsty
Pigsty v1.2: PG14 Default, Monitor Existing PGPigsty
Pigsty v1.1: Homepage, Jupyter, Pev2, PgBadgerPigsty
The WeChat Photo Album Access IssueEssay
Life at 28Essay
Pigsty v1.0: GA Release with Monitoring OverhaulPigsty
Majestic Southern TaihangTravel
On the Hills of ManchuriaTravel
Ready-to-Use PostgreSQL Distribution: PigstyPostgreSQLPigstyRDS
Why Does PostgreSQL Have a Bright Future?PostgreSQLPG Ecosystem
Pigsty v0.9: CLI + LogsPigsty
Pigsty v0.8: Service ProvisioningPigsty
Localization and Collation Rules in PostgreSQLPostgreSQLPG Admin
Implementing Advanced Fuzzy SearchPostgreSQLPG Development
PostgreSQL Logical Replication Deep DivePostgreSQLPG Admin
PG Replica Identity ExplainedPostgreSQLPG AdminPG Development
Pigsty v0.7: Monitor-Only DeploymentsPigsty
A Methodology for Diagnosing PostgreSQL Slow QueriesPostgreSQLPG AdminPerformance
Incident-Report: Patroni Failure Due to Time TravelPostgreSQLPG AdminIncident
Pigsty v0.6: Provisioning UpgradesPigsty
Urban Wandering: Guangzhou ObservationsTravel
Online Primary Key Column Type ChangePostgreSQLPG Admin
New Year Pilgrimage: Yubeng Mountain CircuitTravel
Farewell to GrandfatherEssay
Pigsty v0.5: Declarative DB TemplatesPigsty
Pigsty v0.4: PG13 and Better DocsPigsty
Golden Monitoring Metrics: Errors, Latency, Throughput, SaturationPostgreSQLPG AdminMonitoring
Pigsty v0.3: First Public BetaPigsty
Paradise Found: Wusun Ancient TrailTravel
Database Cluster Management Concepts and Entity Naming ConventionsPostgreSQLPG AdminArchitecture
PostgreSQL's KPIPostgreSQLPG AdminMonitoring
Practical Cryptography Made SimpleEssay
Online PostgreSQL Column Type MigrationPostgreSQLPG AdminMigration
Transaction Isolation Level ConsiderationsPostgreSQLPG Development
Frontend-Backend Communication Wire ProtocolPostgreSQLPG DevelopmentPG Kernel
Incident: PostgreSQL Extension Installation Causes Connection FailurePostgreSQLPG AdminExtensionIncident
CDC Change Data Capture MechanismsPostgreSQLPG Development
Locks in PostgreSQLPostgreSQLPG DevelopmentPG Admin
O(n2) Complexity of GIN SearchPostgreSQLPG Development
City Upon a Hill: California Road TripTravel
PostgreSQL Common Replication Topology PlansPostgreSQLPG AdminArchitecture
Warm Standby: Using pg_receivewalPostgreSQLPG AdminBackup
Is running postgres in docker a good idea?DatabaseContainersArchitecture
The Sorrow of the InternetEssay
Understanding Time - Leap Years, Leap Seconds, Time and Time ZonesPG DevelopmentDatabase
Incident-Report: Connection-Pool Contamination Caused by pg_dumpPostgreSQLPG AdminIncident
New Year ReflectionsEssay
The Internet WinterEssay
Knowledge of China's Administrative DivisionsEssay
PostgreSQL Data Page Corruption RepairPostgreSQLPG AdminIncident
Understanding the InternetEssay
Relation Bloat Monitoring and ManagementPostgreSQLPG Admin
Everest East Face: Gamma Gou TrekkingTravel
TimescaleDB Quick StartPostgreSQLPG AdminExtension
Getting Started with PipelineDBPostgreSQLPG AdminExtension
Incident-Report: PostgreSQL Transaction ID WraparoundPostgreSQLPG AdminIncident
Incident-Report: Integer Overflow from Rapid Sequence Number ConsumptionPostgreSQLPG AdminIncident
Several Levels of Learning KnowledgeEssay
PostgreSQL Trigger Usage ConsiderationsPostgreSQLPG Development
GeoIP Geographic Reverse Lookup OptimizationPostgreSQLPG DevelopmentExtensionGIS
Understanding Character Encoding PrinciplesPG DevelopmentDatabase
Understanding Character EncodingEssay
PostgreSQL Development Convention (2018 Edition)PostgreSQLPG DevelopmentSoftware Engineering
Concurrency Anomalies ExplainedDatabaseTransactionsPG Kernel
What Are PostgreSQL's Advantages?PostgreSQLPG Ecosystem
Blockchain and Distributed DatabasesDatabaseDistributed Systems
KNN Ultimate Optimization: From RDS to PostGISPostgreSQLPG DevelopmentMachine LearningGIS
Efficient Administrative Region Lookup with PostGISPostgreSQLPG DevelopmentGIS
Monitoring Table Size in PostgreSQLPostgreSQLPG AdminMonitoring
Consistency: An Overloaded TermDatabaseDistributed SystemsTransactions
Why Study Database PrinciplesDatabaseCareer
PgAdmin Installation and ConfigurationPostgreSQLPG AdminTools
Incident-Report: Uneven Load AvalanchePostgreSQLPG AdminIncident
Implementing Mutual Exclusion Constraints with ExcludePostgreSQLPG Development
Function Volatility Classification LevelsPostgreSQLPG Development
Distinct On: Remove Duplicate DataPostgreSQLPG Development
PostgreSQL Routine MaintenancePostgreSQLPG Admin
Backup and Recovery Methods OverviewPostgreSQLPG AdminBackup
Pgbouncer Quick StartPostgreSQLPG Admin
PgBackRest2 DocumentationPostgreSQLPG AdminBackup
Changing Engines Mid-Flight — PostgreSQL Zero-Downtime Data MigrationPostgreSQLPG AdminMigration
Using sysbench to Test PostgreSQL PerformancePostgreSQLPG AdminPerformance
Testing Disk Performance with FIOPostgreSQLPG AdminPerformance
PostgreSQL Server Log Regular ConfigurationPostgreSQLPG AdminMonitoring
Finding Unused IndexesPostgreSQLPG Admin
Batch Configure SSH Passwordless LoginPostgreSQLPG Admin
Wireshark Packet Capture Protocol AnalysisPostgreSQLPG AdminTools
The Versatile file_fdw — Reading System Information from Your DatabasePostgreSQLPG AdminExtension
Shangri-La: Luoke Line Trekking JournalTravel
Installing PostGIS from SourcePostgreSQLPG AdminExtension
Common Linux Statistics CLI ToolsPostgreSQLPG AdminTools
Go Database Tutorial: database/sqlPostgreSQLSoftware Engineering
Implementing Cache Synchronization with Go and PostgreSQLPostgreSQLPG Development
Auditing Data Changes with TriggersPostgreSQLPG Development
Basic Principles of Neural NetworksAI
Statistics Fundamentals: Descriptive StatisticsAI
Inferential Statistics: The Past and Present of p-valuesAI
Building an ItemCF Recommender in Pure SQLPostgreSQLPG DevelopmentMachine Learning
Basic Concepts of Probability TheoryAI
Starting from /0: Understanding Errors and ExceptionsEssay
UUID Properties, Principles and ApplicationsPostgreSQLPG DevelopmentArchitecture
Tag Classification TheoryEssay
Switzerland of Northern Xinjiang: Kanas TrekkingTravel
Overview of Sorting AlgorithmsEssay
PostgreSQL MongoFDW Installation and DeploymentPostgreSQLPG AdminExtension
Fundamentals of Information Theory: EntropyAI
Baiji 1509 Training ReflectionsEssay
2014 Year-End SummaryEssay
On Computational ThinkingEssay
In Praise of MathematicsEssay
Humans, Society, and Neural NetworksAI
2013 Year-End SummaryEssay
Computer Networks and Logistics SystemsEssay
Worldview, Values, and Life PhilosophyEssay
On the Hierarchy of KnowledgeEssay
Thinking Characteristics of Eastern and Western PeopleEssay
What Exactly Are Natural Numbers?Essay
Fundamental Concepts of Linear AlgebraAI
Views on LoveEssay

The WeChat Photo Album Access Issue

Ruohang Feng 770 words 4 min

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

Ruohang Feng 1432 words 7 min

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 …

  • The WeChat Photo Album Access Issue

    By Ruohang Feng In Miscs 770 words 4 min

    Ruohang FengEssay

    Featured Image for 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

    By Ruohang Feng In Miscs 1432 words 7 min

    Ruohang FengEssay

    Featured Image for 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

    By Ruohang Feng In PIGSTY 1422 words 7 min

    Ruohang FengPigstyPigsty

    Featured Image for 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 …

  • Majestic Southern Taihang

    By Ruohang Feng In Trips 0 words 1 min

    Ruohang FengTravel

    Featured Image for Majestic Southern Taihang

  • On the Hills of Manchuria

    By Ruohang Feng In Trips 186 words 1 min

    Ruohang FengTravel

    Featured Image for 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

    By Ruohang Feng In PGSQL 2044 words 10 min

    Ruohang FengPostgreSQLPigstyRDS

    Featured Image for 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?

    By Ruohang Feng In PGSQL 4900 words 24 min

    Ruohang FengPostgreSQLPG Ecosystem

    Featured Image for 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

    By Ruohang Feng In PIGSTY 262 words 2 min

    Ruohang FengPigstyPigsty

    Featured Image for 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

    By Ruohang Feng In PIGSTY 183 words 1 min

    Ruohang FengPigstyPigsty

    Featured Image for 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

    By Ruohang Feng In PGSQL 2707 words 6 min

    Ruohang FengPostgreSQLPG Admin

    Featured Image for 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

    By Ruohang Feng In PGSQL 3238 words 7 min

    Ruohang FengPostgreSQLPG Development

    Featured Image for 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

    By Ruohang Feng In PGSQL 6503 words 31 min

    Ruohang FengPostgreSQLPG Admin

    Featured Image for 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

    By Ruohang Feng In PGSQL 2202 words 11 min

    Ruohang FengPostgreSQLPG AdminPG Development

    Featured Image for 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 …

  • Pigsty v0.7: Monitor-Only Deployments

    By Ruohang Feng In PIGSTY 270 words 2 min

    Ruohang FengPigstyPigsty

    Featured Image for Pigsty v0.7: Monitor-Only Deployments

    GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.7.0 Pigsty v0.7 focuses on plugging existing fleets into Pigsty’s observability stack. The new monitor-only flow lets you drop Pigsty dashboards onto databases that were provisioned …

    GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.7.0 Pigsty v0.7 focuses on plugging existing fleets into Pigsty’s observability stack. The new monitor-only flow lets you drop Pigsty dashboards onto databases that were provisioned …

  • A Methodology for Diagnosing PostgreSQL Slow Queries

    By Ruohang Feng In PGSQL 349 words 2 min

    Ruohang FengPostgreSQLPG AdminPerformance

    Featured Image for A Methodology for Diagnosing PostgreSQL Slow Queries

    “You can’t optimize what you can’t measure.” Slow queries hog connections, hold locks, block replication, trigger deadlocks, and waste resources. Every DBA must know how to find and fix them quickly. Traditional tools pg_stat_statements – essential …

    “You can’t optimize what you can’t measure.” Slow queries hog connections, hold locks, block replication, trigger deadlocks, and waste resources. Every DBA must know how to find and fix them quickly. Traditional tools pg_stat_statements – essential …

  • Incident-Report: Patroni Failure Due to Time Travel

    By Ruohang Feng In PGSQL 145 words 1 min

    Ruohang FengPostgreSQLPG AdminIncident

    Featured Image for Incident-Report: Patroni Failure Due to Time Travel

    Summary: Machine restarted due to failure, NTP service corrected PG time after PG startup, causing Patroni to fail to start. The failure information in Patroni is shown as follows: Process %s is not postmaster, too much difference between PID file …

    Summary: Machine restarted due to failure, NTP service corrected PG time after PG startup, causing Patroni to fail to start. The failure information in Patroni is shown as follows: Process %s is not postmaster, too much difference between PID file …

  • Pigsty v0.6: Provisioning Upgrades

    By Ruohang Feng In PIGSTY 202 words 1 min

    Ruohang FengPigstyPigsty

    Featured Image for Pigsty v0.6: Provisioning Upgrades

    GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.6.0 Pigsty v0.6 responds to user feedback with a redesigned provisioning path plus a monitoring stack that can sit beside any managed PG fleet—even a MyBase cluster built elsewhere. Bug …

    GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.6.0 Pigsty v0.6 responds to user feedback with a redesigned provisioning path plus a monitoring stack that can sit beside any managed PG fleet—even a MyBase cluster built elsewhere. Bug …

  • Urban Wandering: Guangzhou Observations

    By Ruohang Feng In Trips 1633 words 8 min

    Ruohang FengTravel

    Featured Image for Urban Wandering: Guangzhou Observations

    Taking advantage of attending the 2020 PostgreSQL China Conference, I toured Guangzhou for a day. A quite interesting place. Among the four first-tier cities, only Guangzhou remained unvisited. This time, leveraging the PG conference opportunity, I …

    Taking advantage of attending the 2020 PostgreSQL China Conference, I toured Guangzhou for a day. A quite interesting place. Among the four first-tier cities, only Guangzhou remained unvisited. This time, leveraging the PG conference opportunity, I …

  • Online Primary Key Column Type Change

    By Ruohang Feng In PGSQL 1169 words 6 min

    Ruohang FengPostgreSQLPG Admin

    Featured Image for Online Primary Key Column Type Change

    Author: Vonng (@Vonng) How to change primary key column types online, such as upgrading from INT to BIGINT, without affecting business operations? Suppose you have a table in PostgreSQL where you initially chose an INT primary key without much …

    Author: Vonng (@Vonng) How to change primary key column types online, such as upgrading from INT to BIGINT, without affecting business operations? Suppose you have a table in PostgreSQL where you initially chose an INT primary key without much …

  • New Year Pilgrimage: Yubeng Mountain Circuit

    By Ruohang Feng In Trips 1326 words 7 min

    Ruohang FengTravel

    Featured Image for New Year Pilgrimage: Yubeng Mountain Circuit

    The disaster-filled year 2020 required proper blessings. Completed the Meili inner circuit in 3 days - Sacred Waterfall, Sacred Lake, Ice Lake. Preface: As the saying goes: “If not going to paradise, go to Yubeng.” Going to Yubeng usually means …

    The disaster-filled year 2020 required proper blessings. Completed the Meili inner circuit in 3 days - Sacred Waterfall, Sacred Lake, Ice Lake. Preface: As the saying goes: “If not going to paradise, go to Yubeng.” Going to Yubeng usually means …

  • Farewell to Grandfather

    By Ruohang Feng In Miscs 2088 words 10 min

    Ruohang FengEssay

    Featured Image for Farewell to Grandfather

    Although 2020 was a year of many disasters, until grandfather’s death, I always thought we could somehow get by. The death of a close relative—this is the second time for me. First my father, then my grandfather. Humans appear so powerless before …

    Although 2020 was a year of many disasters, until grandfather’s death, I always thought we could somehow get by. The death of a close relative—this is the second time for me. First my father, then my grandfather. Humans appear so powerless before …

  • Pigsty v0.5: Declarative DB Templates

    By Ruohang Feng In PIGSTY 680 words 4 min

    Ruohang FengPigstyPigsty

    Featured Image for Pigsty v0.5: Declarative DB Templates

    GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.5.0 v0.5.0 Outline The official docs site (http://pigsty.cc/) is live. Database templating becomes fully declarative: define users, roles, databases, ACLs, extensions, and schemas in …

    GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.5.0 v0.5.0 Outline The official docs site (http://pigsty.cc/) is live. Database templating becomes fully declarative: define users, roles, databases, ACLs, extensions, and schemas in …

  • Pigsty v0.4: PG13 and Better Docs

    By Ruohang Feng In PIGSTY 167 words 1 min

    Ruohang FengPigstyPigsty

    Featured Image for Pigsty v0.4: PG13 and Better Docs

    GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.4.0 Pigsty v0.4 is our second public beta. The observability stack was rebuilt around Grafana 7.3, and ten curated dashboards became the default open-source payload. pg_exporter 0.3.1 …

    GitHub Release: https://github.com/pgsty/pigsty/releases/tag/v0.4.0 Pigsty v0.4 is our second public beta. The observability stack was rebuilt around Grafana 7.3, and ten curated dashboards became the default open-source payload. pg_exporter 0.3.1 …

  • Golden Monitoring Metrics: Errors, Latency, Throughput, Saturation

    By Ruohang Feng In PGSQL 1235 words 6 min

    Ruohang FengPostgreSQLPG AdminMonitoring

    Featured Image for Golden Monitoring Metrics: Errors, Latency, Throughput, Saturation

    Preface Playing with databases and playing with cars have something in common - they both require frequently checking the dashboard. What are you doing staring at the dashboard? Looking at metrics. Why look at metrics? You need to understand the …

    Preface Playing with databases and playing with cars have something in common - they both require frequently checking the dashboard. What are you doing staring at the dashboard? Looking at metrics. Why look at metrics? You need to understand the …