{"id":23682,"date":"2026-03-13T06:16:20","date_gmt":"2026-03-12T21:16:20","guid":{"rendered":"https:\/\/aireviewirush.com\/?p=23682"},"modified":"2026-03-13T06:16:20","modified_gmt":"2026-03-12T21:16:20","slug":"why-postgres-has-gained-because-the-de-facto-database-in-the-present-day-and-for-the-agentic-future","status":"publish","type":"post","link":"https:\/\/aireviewirush.com\/?p=23682","title":{"rendered":"Why Postgres\u00ae has gained because the de facto database: In the present day and for the agentic future"},"content":{"rendered":"<p> <br \/>\n<br \/><img decoding=\"async\" src=\"https:\/\/www.infoworld.com\/wp-content\/uploads\/2026\/03\/4144502-0-30326000-1773339235-shutterstock_1319520974_661b05.jpg?quality=50&amp;strip=all\" alt=\"\"><\/p>\n<div>\n<section class=\"wp-block-bigbite-multi-title\"\/>\n<p>The AI financial system is projected to achieve\u00a0<a href=\"https:\/\/www.mckinsey.com\/capabilities\/tech-and-ai\/our-insights\/the-economic-potential-of-generative-ai-the-next-productivity-frontier\" target=\"_blank\" rel=\"noopener\">$17 trillion<\/a>\u00a0by 2028, basically altering how organizations architect their infrastructure. Pushed by this shift,\u00a0<a href=\"https:\/\/www.enterprisedb.com\/sovereignty-matters\" target=\"_blank\" rel=\"noopener\">95% of main international enterprises<\/a>\u00a0are on a mission-critical dash to develop into their very own AI and information platforms throughout the subsequent two years.\u00a0<\/p>\n<p>But solely 13% of enterprises have efficiently discovered the system. Their secret to mainstreaming agentic AI? Abandoning fragmented, legacy architectures and inserting their information instantly alongside their AI in a safe, compliant, and sovereign method.<\/p>\n<p>As organizations quickly transition to an \u201cagentic\u201d workforce, they&#8217;re getting into a extremely unstable, unsure, complicated, and ambiguous (VUCA) surroundings. Surviving this shift requires abandoning inflexible, conventional methods in favor of agility and resilience. For enterprises main the cost, the foundational layer of selection is obvious: true open supply relational databases. In the present day, 81% of those profitable enterprises have dedicated to open supply methods, with over 40% standardizing on PostgreSQL as their relational information layer.<\/p>\n<p>As Doug Flora, VP of Product Advertising and marketing at\u00a0<a href=\"https:\/\/www.enterprisedb.com\/\" target=\"_blank\" rel=\"noopener\">EnterpriseDB<\/a>\u00a0(EDB), famous: \u201cIt\u2019s crucial in moments of fast change to comply with the patterns of the leaders seeking to forge success, not the bulk who&#8217;re nonetheless working within the patterns of the latest previous. These committing to open supply and a mission-critical give attention to sovereignty over their AI and information are plotting a pathway to agentic success that achieves 5x the ROI of the bulk.\u201d<\/p>\n<p><strong>Extensibility issues: AI wants each structured and unstructured information<\/strong><\/p>\n<p>AI functions can not run on vector embeddings alone; they require a deep synthesis of structured, semi-structured, and unstructured information. Not like many legacy databases that bolt on new options as afterthoughts, Postgres was natively architected for core\u00a0<a href=\"https:\/\/www.enterprisedb.com\/blog\/part-2-postgresqls-incredible-trip-top-developers\" target=\"_blank\" rel=\"noopener\">extensibility<\/a>. It empowers builders to increase information sorts, indexes, question planners, features, and storage engines dynamically.\u00a0<\/p>\n<p>By unifying vectorized information with conventional transactional (binary) information, Postgres successfully provides AI brokers the \u201ceyes, ears, and mind\u201d essential to sense inputs and function autonomously inside a single, ACID-compliant surroundings.<\/p>\n<p><strong>An ecosystem constructed for architectural agility\u00a0<\/strong><\/p>\n<p>In a quickly increasing information ecosystem, counting on a fragmented structure of specialised databases creates complicated synaptic connectors liable to latency, integration failures, and information silos\u2014or what quantities to human hallucinations on the system degree. Postgres eliminates this technical debt by extending a single database engine to satisfy various workload calls for.<\/p>\n<p>\u201cBuilders have lengthy beloved Postgres for its extensibility, flexibility, and open innovation mannequin. Now international enterprises are recognizing that very same worth, making Postgres a strategic choice and working mission-critical information programs on it,\u201d stated Jozef de Vries, SVP, Core Database Engineering, EDB.<\/p>\n<p>Builders can seamlessly prolong Postgres to deal with extremely complicated, unstable workloads:<\/p>\n<ul class=\"wp-block-list\">\n<li><strong>pgvector:<\/strong>\u00a0Allows superior vector search, permitting builders to mix relational information, metadata, and embeddings to construct strong retrieval-augmented era (RAG) functions<\/li>\n<li><strong>Citus:<\/strong>\u00a0Accelerates multi-tenant SaaS functions and powers real-time analytics (HTAP) through clear sharding and parallel question execution<\/li>\n<li><strong>PostGIS:<\/strong>\u00a0Delivers enterprise-grade geospatial querying, essential for protection and retail industries<\/li>\n<li><strong>TimescaleDB:<\/strong>\u00a0Manages huge time-series information essential for complicated analytic fashions and agentic studying patterns<\/li>\n<li><strong>pgraph:<\/strong>\u00a0Handles complicated, interconnected information traversals to uncover hidden relationships<\/li>\n<\/ul>\n<p><strong>The longer term wants crowdsourced intelligence, not vendor lock-in<\/strong><\/p>\n<p>Crucially, no single company entity owns Postgres. Its vitality depends on the collective intelligence of one of many largest unbiased developer communities on the planet. In 2025 alone, greater than<a href=\"https:\/\/rhaas.blogspot.com\/2026\/01\/who-contributed-to-postgresql.html?\" target=\"_blank\" rel=\"noopener\">\u00a0260 builders\u00a0<\/a>contributed code on to PostgreSQL\u2019s core database engine, with lots of extra collaborating in testing, critiques, and documentation internationally. Past the codebase, the ecosystem is supported by lots of of consumer teams, meetups, and worldwide PostgreSQL conferences that maintain innovation flowing throughout all 5 continents.<\/p>\n<p>Whereas enterprise-grade platforms are constructed round Postgres to optimize it for sovereign, agentic environments\u2014with huge tech giants among the many prime business contributors and\u00a0<a href=\"http:\/\/www.enterprisedb.com\/company\/postgres-vitality-index\" target=\"_blank\" rel=\"noopener\">EDB main with greater than 30%\u00a0<\/a><a href=\"http:\/\/www.enterprisedb.com\/company\/postgres-vitality-index\" target=\"_blank\" rel=\"noopener\">of\u00a0<\/a><a href=\"http:\/\/www.enterprisedb.com\/company\/postgres-vitality-index\" target=\"_blank\" rel=\"noopener\">contributions<\/a>\u2014its innovation comes instantly from this wealthy and various neighborhood that continues to broaden. Drawing on the rules of\u00a0<a href=\"https:\/\/www.asecib.ase.ro\/mps\/TheWisdomOfCrowds-JamesSurowiecki.pdf\" target=\"_blank\" rel=\"noopener\">James Surowiecki\u2019s\u00a0<\/a><a href=\"https:\/\/www.asecib.ase.ro\/mps\/TheWisdomOfCrowds-JamesSurowiecki.pdf\" target=\"_blank\" rel=\"noopener\"><em>The Knowledge of Crowds<\/em><\/a>, this crowdsourced intelligence ensures that the database evolves sooner and extra robustly than it could in any proprietary, single-vendor ecosystem.<\/p>\n<p><strong>Securing a sovereign information future<\/strong><\/p>\n<p>To thrive within the agentic future, engineering and information leaders should make two essential architectural strikes: First, break away from locked-in legacy relational ecosystems, corresponding to\u00a0<a href=\"https:\/\/www.enterprisedb.com\/sites\/default\/files\/pdf\/Best_Practices_for_Oracle_Migration.pdf\" target=\"_blank\" rel=\"noopener\">Oracle<\/a>,\u00a0<a href=\"https:\/\/www.enterprisedb.com\/move-beyond-mysql-future-proof-postgres\" target=\"_blank\" rel=\"noopener\">MySQL<\/a>,\u00a0<a href=\"https:\/\/www.enterprisedb.com\/sites\/default\/files\/pdf\/Best_Practices_for_Non-Oracle_Migration.pdf\" target=\"_blank\" rel=\"noopener\">SQL Server<\/a>, or\u00a0<a href=\"https:\/\/www.enterprisedb.com\/blog\/data-warehouse-modernization-edb-postgres-ai-and-greenplum-compatibility\" target=\"_blank\" rel=\"noopener\">Greenplum<\/a>\u00a0, that constrain agility.<\/p>\n<p>Second, harness the immense extensibility of Postgres, its vibrant open supply neighborhood, and its core ACID capabilities to unify information and AI.<\/p>\n<p>The way forward for enterprise structure isn\u2019t about renting area in a hyperscaler\u2019s proprietary ecosystem. It\u2019s about creating your individual sovereign platform, the place your structured and unstructured information seamlessly energy a brand new agentic workforce beneath your full management. Transfer your information to Postgres now, or danger lacking the inspiration of the agentic future.<\/p>\n<p><em>Get your complimentary copy of the O\u2019Reilly guide\u00a0<\/em><a href=\"https:\/\/www.enterprisedb.com\/resources\/building-a-data-and-ai-platform-with-postgresql\/?utm_source=adv&amp;utm_medium=pa&amp;utm_campaign=adv_ww_in_oreillybook-\" target=\"_blank\" rel=\"noopener\"><em>Constructing a Knowledge and AI Platform with PostgreSQL<\/em><\/a><em>.<\/em><\/p>\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n<\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>The AI financial system is projected to achieve\u00a0$17 trillion\u00a0by 2028, basically altering how organizations architect their infrastructure. Pushed by this shift,\u00a095% of main international enterprises\u00a0are on a mission-critical dash to develop into their very own AI and information platforms throughout the subsequent two years.\u00a0 But solely 13% of enterprises have efficiently discovered the system. Their [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":23684,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-23682","post","type-post","status-publish","format-standard","has-post-thumbnail","category-cloud-computing"],"_links":{"self":[{"href":"https:\/\/aireviewirush.com\/index.php?rest_route=\/wp\/v2\/posts\/23682","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aireviewirush.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aireviewirush.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aireviewirush.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aireviewirush.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=23682"}],"version-history":[{"count":1,"href":"https:\/\/aireviewirush.com\/index.php?rest_route=\/wp\/v2\/posts\/23682\/revisions"}],"predecessor-version":[{"id":23683,"href":"https:\/\/aireviewirush.com\/index.php?rest_route=\/wp\/v2\/posts\/23682\/revisions\/23683"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aireviewirush.com\/index.php?rest_route=\/wp\/v2\/media\/23684"}],"wp:attachment":[{"href":"https:\/\/aireviewirush.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=23682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aireviewirush.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=23682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aireviewirush.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=23682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}