Why Postgres® has won as the de facto database: Today and for the agentic future

The AI economy is on a trajectory to reach an impressive trillion by 2028, prompting organizations to rethink their infrastructure strategies. In response to this transformative shift, a staggering 95% of major global enterprises are racing to establish their own AI and data platforms within the next two years.

However, a mere 13% of these enterprises have successfully navigated this complex landscape. Their key to integrating agentic AI lies in discarding outdated, fragmented architectures in favor of a cohesive approach that places data alongside AI in a secure, compliant, and sovereign manner.

Embracing Agility in a VUCA World

As organizations transition to an “agentic” workforce, they find themselves in a volatile, uncertain, complex, and ambiguous (VUCA) environment. To thrive in this new reality, companies must abandon rigid, traditional strategies in favor of agility and resilience. For those at the forefront of this movement, the choice of foundational technology is clear: true open-source relational databases. Currently, 81% of successful enterprises have adopted open-source strategies, with over 40% standardizing on PostgreSQL as their relational data layer.

Doug Flora, VP of Product Marketing at EnterpriseDB (EDB), emphasizes the importance of following the lead of innovators: “In moments of rapid change, it’s crucial to align with the patterns of leaders aiming for success, rather than the majority still adhering to outdated methods. Those who commit to open source and prioritize sovereignty over their AI and data are paving the way for agentic success, achieving five times the ROI of their counterparts.”

Extensibility Matters: AI Needs Diverse Data

AI applications require more than just vector embeddings; they demand a rich integration of structured, semi-structured, and unstructured data. Unlike many legacy systems that treat new features as afterthoughts, PostgreSQL was designed with extensibility at its core. This architecture empowers developers to dynamically extend data types, indexes, query planners, functions, and storage engines.

By merging vectorized data with traditional transactional data, PostgreSQL equips AI agents with the necessary “eyes, ears, and brain” to process inputs and operate autonomously within a single, ACID-compliant environment.

An Ecosystem Built for Architectural Agility

In an ever-expanding data landscape, relying on a fragmented architecture of specialized databases can lead to latency, integration failures, and data silos—akin to systemic hallucinations. PostgreSQL mitigates this technical debt by providing a unified database engine capable of addressing diverse workload demands.

“Developers have long appreciated PostgreSQL for its extensibility, flexibility, and open innovation model. Now, global enterprises are recognizing these same values, making PostgreSQL a strategic choice for mission-critical data systems,” remarked Jozef de Vries, SVP of Core Database Engineering at EDB.

Developers can effortlessly extend PostgreSQL to manage complex, dynamic workloads:

  • pgvector: Facilitates advanced vector search, enabling the integration of relational data, metadata, and embeddings for robust retrieval-augmented generation (RAG) applications.
  • Citus: Enhances multi-tenant SaaS applications and powers real-time analytics (HTAP) through transparent sharding and parallel query execution.
  • PostGIS: Provides enterprise-grade geospatial querying, essential for sectors like defense and retail.
  • TimescaleDB: Efficiently manages extensive time-series data, vital for complex analytics and agentic learning patterns.
  • pgraph: Navigates complex, interconnected data traversals to reveal hidden relationships.

The Future Needs Crowdsourced Intelligence

Importantly, PostgreSQL is not owned by any single corporate entity. Its vitality stems from the collective intelligence of one of the largest independent developer communities globally. In 2025 alone, over 260 developers contributed directly to PostgreSQL’s core engine, with many more involved in testing, reviews, and documentation worldwide. This ecosystem is further bolstered by numerous user groups, meetups, and international PostgreSQL conferences that foster ongoing innovation.

While enterprise-grade platforms are built around PostgreSQL to optimize it for sovereign, agentic environments—with significant contributions from major tech companies and EDB leading with over 30% of contributions—its innovation is driven by this rich and diverse community. Drawing on the principles of The Wisdom of Crowds by James Surowiecki, this crowdsourced intelligence ensures that the database evolves more rapidly and robustly than it could in any proprietary, single-vendor ecosystem.

Securing a Sovereign Data Future

To succeed in the agentic future, engineering and data leaders must undertake two pivotal architectural shifts: first, liberate themselves from legacy relational ecosystems such as Oracle, MySQL, SQL Server, or Greenplum, which hinder agility.

Second, leverage the extensive extensibility of PostgreSQL, its vibrant open-source community, and its core ACID capabilities to unify data and AI.

The future of enterprise architecture lies not in renting space within a hyperscaler’s proprietary ecosystem but in crafting a sovereign platform where structured and unstructured data seamlessly drive a new agentic workforce under complete control. Transitioning to PostgreSQL now is essential to laying the groundwork for the agentic future.

Get your complimentary copy of the O’Reilly book Building a Data and AI Platform with PostgreSQL.


Tech Optimizer
Why Postgres® has won as the de facto database: Today and for the agentic future