# PostgreSQL Mage

> PostgreSQL ecosystem news, plus development, operations, internals and tuning.

---

LLMS index: [llms.txt](/llms.txt)

---

Section pages:

- [Chinese PostgreSQL Docs Are Live: All 11 Major Versions](/pg/pgsql-cc-online/)
- [Happy 30th Birthday, PostgreSQL](/pg/happy-30-birthday/)
- [Instantly Clone PostgreSQL Databases—No Black Magic Required](/pg/pg-pig-clone/)
- [What Is a PostgreSQL Distribution?](/pg/what-is-pg-distro/)
- [Extensions for Everyone](/pg/extensions-for-everyone/)
- [PGConf.Dev 2026 Opens Today in Vancouver](/pg/pgcfd2026-intro/)
- [The pgBackRest Rescue and Open Source's Forced Price Discovery](/pg/pgbackrest-resume/)
- [pgBackRest is No Longer Maintained](/pg/pgbackrest-archive/)
- [504 Extensions: Expand the PostgreSQL Landscape](/pg/extension-504/)
- [PostgreSQL vs. MySQL in 2026](/pg/pg-vs-mysql-2026/)
- [Is Oracle-Compatible Postgres Actually Useful?](/pg/ivorysql/)
- [Urgent Advisory: Pause PostgreSQL Minor-Release Installs and Upgrades](/pg/pg-out-of-sync-202602/)
- [From AGPL to Apache: Why I Changed Pigsty's License](/pg/pigsty-relicense/)
- [How to Actually Do PostgreSQL High Availability](/pg/pg-ha-sota/)
- [Git for Data: Instant PostgreSQL Database Cloning](/pg/pg-clone/)
- [Why PostgreSQL Will Dominate the AI Era](/pg/ai-db-king/)
- [Forging a China-Rooted, Global PostgreSQL Distro](/pg/forge-a-pg-distro/)
- [PG Extension Cloud: Unlocking PostgreSQL’s Entire Ecosystem](/pg/pgext-cloud/)
- [The PostgreSQL 'Supply Cut' and Trust Issues in Software Supply Chain](/pg/pg-mirror-pigsty/)
- [Column: Postgres Mage](/pg/mage/)
- [PostgreSQL Dominates Database World, but Who Will Devour PG?](/pg/proprity-pg/)
- [PostgreSQL Has Dominated the Database World](/pg/so2025-pg/)
- [PGDG Cuts Off Mirror Sync Channel](/pg/pg-mirror-break/)
- [Postgres Extension Day - See You There!](/pg/pgext-day/)
- [OrioleDB is Coming! 4x Performance, Eliminates Pain Points, Storage-Compute Separation](/pg/orioledb-is-coming/)
- [OpenHalo: MySQL Wire-Compatible PostgreSQL is Here!](/pg/openhalo-mysql/)
- [PGFS: Using Database as a Filesystem](/pg/pgfs/)
- [PostgreSQL Ecosystem Frontier Developments](/pg/pg-frontier/)
- [Pig, The Postgres Extension Wizard](/pg/pig/)
- [Don't Upgrade! Released and Immediately Pulled - Even PostgreSQL Isn't Immune to Epic Fails](/pg/pg-faint/)
- [PostgreSQL 12 End-of-Life, PG 17 Takes the Throne](/pg/pg12-eol-pg17-up/)
- [The Ideal Way to Deliver PostgreSQL Extensions](/pg/pg-ext-repo/)
- [PostgreSQL 17 Released: No More Pretending!](/pg/pg-17/)
- [Can PostgreSQL Replace Microsoft SQL Server?](/pg/pg-replace-mssql/)
- [Whoever Integrates DuckDB Best Wins the OLAP World](/pg/pg-duckdb/)
- [StackOverflow 2024 Survey: PostgreSQL Has Gone Completely Berserk](/pg/pg-is-no1-again/)
- [Self-Hosting Dify with PG, PGVector, and Pigsty](/pg/dify-setup/)
- [PGCon.Dev 2024, The conf that shutdown PG for a week](/pg/pgcondev-2024/)
- [PostgreSQL 17 Beta1 Released!](/pg/pg-17-beta1/)
- [Postgres is eating the database world](/pg/pg-eat-db-world/)
- [Technical Minimalism: Just Use PostgreSQL for Everything](/pg/just-use-pg/)
- [New PostgreSQL Ecosystem Player: ParadeDB](/pg/paradedb/)
- [PostgreSQL's Impressive Scalability](/pg/pg-scalability/)
- [PostgreSQL Wins 2024 Database of the Year Award! (Fifth Time)](/pg/pg-dbeng-2024/)
- [PostgreSQL Convention 2024](/pg/pg-convention/)
- [PostgreSQL Macro Query Optimization with pg_stat_statements](/pg/pgss/)
- [FerretDB: PostgreSQL Disguised as MongoDB](/pg/ferretdb/)
- [How to Use pg_filedump for Data Recovery?](/pg/pg-filedump/)
- [PostgreSQL, The most successful database](/pg/pg-is-no1/)
- [AI Large Models and Vector Database PGVector](/pg/llm-and-pgvector/)
- [How Powerful is PostgreSQL Really?](/pg/pg-performence/)
- [Why PostgreSQL is the Most Successful Database?](/pg/pg-is-best/)
- [Ready-to-Use PostgreSQL Distribution: Pigsty](/pg/pigsty-intro/)
- [Why Does PostgreSQL Have a Bright Future?](/pg/pg-is-great/)
- [Implementing Advanced Fuzzy Search](/pg/fuzzymatch/)
- [Localization and Collation Rules in PostgreSQL](/pg/collate/)
- [PG Replica Identity Explained](/pg/replica-identity/)
- [PostgreSQL Logical Replication Deep Dive](/pg/logical-replication/)
- [A Methodology for Diagnosing PostgreSQL Slow Queries](/pg/slow-query/)
- [Incident-Report: Patroni Failure Due to Time Travel](/pg/time-travel/)
- [Online Primary Key Column Type Change](/pg/alter-type/)
- [Golden Monitoring Metrics: Errors, Latency, Throughput, Saturation](/pg/golden-metrics/)
- [Database Cluster Management Concepts and Entity Naming Conventions](/pg/entity-and-naming/)
- [PostgreSQL's KPI](/pg/pg-load/)
- [Online PostgreSQL Column Type Migration](/pg/migrate-column-type/)
- [Frontend-Backend Communication Wire Protocol](/pg/wire-protocol/)
- [Transaction Isolation Level Considerations](/pg/isolation-level/)
- [Incident: PostgreSQL Extension Installation Causes Connection Failure](/pg/extension/)
- [CDC Change Data Capture Mechanisms](/pg/logical-decoding/)
- [Locks in PostgreSQL](/pg/pg-lock/)
- [O(n2) Complexity of GIN Search](/pg/gin/)
- [PostgreSQL Common Replication Topology Plans](/pg/replication-plan/)
- [Warm Standby: Using pg_receivewal](/pg/backup-plan/)
- [Incident-Report: Connection-Pool Contamination Caused by pg_dump](/pg/pg-dump-failure/)
- [PostgreSQL Data Page Corruption Repair](/pg/page-corruption/)
- [Relation Bloat Monitoring and Management](/pg/bloat/)
- [Getting Started with PipelineDB](/pg/pipeline-intro/)
- [TimescaleDB Quick Start](/pg/timescale-install/)
- [Incident-Report: Integer Overflow from Rapid Sequence Number Consumption](/pg/sequence-overflow/)
- [Incident-Report: PostgreSQL Transaction ID Wraparound](/pg/xid-wrap-around/)
- [GeoIP Geographic Reverse Lookup Optimization](/pg/geoip/)
- [PostgreSQL Trigger Usage Considerations](/pg/sql-trigger/)
- [PostgreSQL Development Convention (2018 Edition)](/pg/pg-convention-2018/)
- [What Are PostgreSQL's Advantages?](/pg/pg-is-good/)
- [Efficient Administrative Region Lookup with PostGIS](/pg/adcode-geodecode/)
- [KNN Ultimate Optimization: From RDS to PostGIS](/pg/knn-optimize/)
- [Monitoring Table Size in PostgreSQL](/pg/mon-table-size/)
- [PgAdmin Installation and Configuration](/pg/pgadmin-install/)
- [Incident-Report: Uneven Load Avalanche](/pg/download-failure/)
- [Distinct On: Remove Duplicate Data](/pg/sql-distinct-on/)
- [Function Volatility Classification Levels](/pg/sql-func-volatility/)
- [Implementing Mutual Exclusion Constraints with Exclude](/pg/sql-exclude/)
- [PostgreSQL Routine Maintenance](/pg/routine-maintain/)
- [Backup and Recovery Methods Overview](/pg/backup-overview/)
- [PgBackRest2 Documentation](/pg/pgbackrest/)
- [Pgbouncer Quick Start](/pg/pgbouncer-usage/)
- [PostgreSQL Server Log Regular Configuration](/pg/logging/)
- [Testing Disk Performance with FIO](/pg/fio/)
- [Using sysbench to Test PostgreSQL Performance](/pg/sysbench/)
- [Changing Engines Mid-Flight — PostgreSQL Zero-Downtime Data Migration](/pg/migration-without-downtime/)
- [Finding Unused Indexes](/pg/find-dummy-index/)
- [Batch Configure SSH Passwordless Login](/pg/ssh-add-key/)
- [Wireshark Packet Capture Protocol Analysis](/pg/wireshark-capture/)
- [The Versatile file_fdw — Reading System Information from Your Database](/pg/file_fdw/)
- [Common Linux Statistics CLI Tools](/pg/unix-tool/)
- [Installing PostGIS from Source](/pg/postgis-install/)
- [Go Database Tutorial: database/sql](/pg/pg-go-driver/)
- [Implementing Cache Synchronization with Go and PostgreSQL](/pg/notify-trigger-based-repl/)
- [Auditing Data Changes with Triggers](/pg/audit-change/)
- [Building an ItemCF Recommender in Pure SQL](/pg/pg-recsys/)
- [UUID Properties, Principles and Applications](/pg/uuid/)
- [PostgreSQL MongoFDW Installation and Deployment](/pg/mongo_fdw-install/)