PostgreSQL 17 Extends Further Extends Capabilities Of Open Source Database
Gestalt IT, Thursday, September 26th, 2024
The latest update to the PostgreSQL database adds incremental backup capabilities that eliminate the need to rely on third-party tools along with a pg_createsubscriber tool that makes logical replication a more viable option for large databases by speeding up the initial data copy process.
PostgreSQL 17 also adds a revamped transaction subsystem capable of improving the performance of some applications by as much as 100% along with a JSON_TABLE and expanded SQL/JSON methods that makes it simpler for developers to build applications that span relational and non-relational data.
Tom Kincaid, senior vice president for database servers and tools for EDB, said the additions will further the adoption of Postgres by, in some cases, eliminating the need for a separate document database for applications based on the JSON data format.