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