EnterpriseDB (EDB), the leading Postgres data and AI company, is unveiling a series of contributions to PostgreSQL 17 that forward the database as an effective option for large-scale data analytics and AI workloads, according to EDB. This release—which was driven by over 200 developers world-wide—reflects the growing popularity and significance of Postgres, as well as EDB’s long-standing commitment to the PostgreSQL community.
Developers have consistently chosen Postgres for its flexibility and extensibility; this trend of selection continues to grow as AI remains top-of-mind for many organizations. According to an EDB study, over one-third of large enterprises (150-plus employees) are considering Postgres for their next project, with 56% of this group believing AI is going mainstream in their organization.
EDB’s latest contributions to Postgres further extend the database to suit the intense demands for AI, offering significant performance, reliability, and versatility improvements for modern workloads. Some key highlights include:
- Built-in incremental backup capabilities for enterprises managing highly dynamic workloads, reducing storage costs and downtime while improving reliability
- Improvements in subtransaction handling and reduced memory requirements for partition-wise JOINs, delivering better scalability and faster query processing even in extremely complex environments
- Introduction of the pg_createsubscriber tool which dramatically accelerates the initial data copy process, making logical replication a more viable option for large databases
- Advancements for SQL:JSON and the introduction of JSON_TABLE and expanded SQL/JSON methods which streamline data processing by reducing the need for complex application logic and enabling developers to maintain queries and transactions that span both relational and non-relational data
“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,” says Jozef de Vries, chief product engineering officer, EDB. “By introducing features like incremental backups and advancing features like 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.”
“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,” says Tom Kincaid, senior vice president, database servers and tools, EDB. “This breakthrough enables an entirely new class of applications to be migrated to Postgres with minimal changes, greatly expanding the database’s applicability.”
To learn more about EDB’s latest contributions to Postgres, please visit https://www.enterprisedb.com/.