BEDFORD, Mass., Sept. 26, 2024 (GLOBE NEWSWIRE) — EnterpriseDB (“EDB”), a prominent player in the realm of Postgres data and AI, has made noteworthy strides in the development of PostgreSQL 17. This release not only reinforces EDB’s status as the leading contributor to the PostgreSQL ecosystem but also enhances the database’s capabilities for large-scale data analytics and AI-driven workloads. With contributions from over 200 developers globally, including 19 from EDB who worked on 24 features, the latest version showcases significant advancements in performance, reliability, and versatility tailored for contemporary data challenges.
Postgres Meets the Demands of Modern Workloads
An insightful study conducted by EDB indicates a rising trend among large enterprises, with over one-third considering Postgres for their upcoming projects. Notably, 56% of these organizations anticipate that AI will become mainstream within their operations—an inclination that surpasses the general market sentiment. This burgeoning interest in Postgres is hardly surprising, given its well-established reputation for flexibility and extensibility among developers.
Jozef de Vries, Chief Product Engineering Officer at EDB, articulated the company’s vision: “Our work on PostgreSQL 17 underscores a belief that Postgres isn’t just a database—it’s a data platform supporting your most critical business systems. By introducing features like incremental backups and enhancing JSON functionality and performance, EDB is doubling down on our commitment to the open source project while enabling enterprises to ‘just use Postgres’ to solve their most pressing data challenges.”
Advancements in Backup, Sub-Transactions, and JSON Support
Among the standout features of PostgreSQL 17 are the newly integrated incremental backup capabilities, which represent a significant leap forward for enterprises handling high-update workloads. Previously reliant on third-party tools and intricate processes, users can now benefit from a streamlined backup and recovery process, thanks to the efforts of EDB’s Chief Database Scientist, Robert Haas, along with contributions from the broader community. This enhancement not only reduces storage costs and downtime but also bolsters reliability.
The release also introduces substantial performance upgrades. “Building on customer feedback, EDB collaborated with the community to overhaul portions of the transaction subsystem, implementing new locking techniques that deliver performance boosts of up to 100x,” explained Tom Kincaid, Senior Vice President, Database Servers and Tools at EDB. “This breakthrough enables an entirely new class of applications to be migrated to Postgres with minimal changes, greatly expanding the database’s applicability.”
Enhancements in subtransaction handling and reduced memory requirements for partition-wise JOINs further facilitate better scalability and accelerated query processing, even in complex environments. Additionally, PostgreSQL 17 introduces the pg_createsubscriber tool, which significantly expedites the initial data copy process, making logical replication a more viable option for large databases.
The advancements extend to SQL:JSON functionality as well, with the introduction of JSON_TABLE and expanded SQL/JSON methods. These features simplify data processing, minimizing the need for convoluted application logic and enabling developers to execute queries and transactions that seamlessly integrate both relational and non-relational data.
EDB’s influence on Postgres transcends technical enhancements. Earlier this year, EDB unveiled EDB Postgres® AI, an intelligent platform designed for transactional, analytical, and AI workloads. In the coming months, EDB plans to share early release chapters for an O’Reilly Animal book titled Building Intelligent Applications with PostgreSQL and AI, which will delve into how Postgres not only meets but exceeds the demands of modern AI applications.
For further details regarding EDB’s contributions to Postgres 17, interested parties can visit: www.enterprisedb.com.
EDB stands as a pivotal entity in the data and AI landscape, empowering organizations to leverage the full potential of Postgres across various workloads in any cloud environment. With a commitment to risk management, cost efficiency, and scalability, EDB serves over 1,500 customers worldwide, including major government entities and financial institutions. The company’s solutions facilitate the modernization of legacy systems and the dismantling of data silos while harnessing the power of enterprise-grade open source technologies. EDB ensures high availability, boasting up to 99.999% uptime, alongside built-in mission-critical capabilities such as security, compliance controls, and observability. For more information, visit www.enterprisedb.com.
EnterpriseDB and EDB are registered trademarks of EnterpriseDB Corporation. Postgres and PostgreSQL are registered trademarks of the PostgreSQL Community Association of Canada and are used with their permission. All other trademarks are owned by their respective owners.
Media Contact:
Shane Smith
Offleash PR for EDB
edb@offleashpr.com