This new characteristic additionally introduces a extra environment friendly methodology of merging incremental backups offline into full backups, decreasing the server load sometimes required for a full backup. Designed and applied by EDB worker and long-time Postgres hacker and committer Robert Haas, this performance is anticipated to be standard amongst DBAs, particularly these managing on-premises Postgres deployments. Moreover, the characteristic features a sturdy set of hooks that allow storage to many alternative targets, in addition to help for options like compression and tarball storage.
New in-core backup performance means quicker restoration occasions, decreasing restoration time targets (RTO) dramatically—a necessary requirement for enterprises operating giant databases or high-availability programs. This makes Postgres an much more enticing choice for organizations the place downtime has vital enterprise impacts, equivalent to these dealing with large-scale analytics and AI workloads.
SQL/JSON and JSON enhancements: Assembly builders’ wants
SQL/JSON is a part of the SQL:2023 customary, offering database builders with a robust set of features for interacting with JSON paperwork in a manner that feels pure to these aware of SQL. Postgres has been progressively enhancing its SQL/JSON performance over the previous a number of releases, however Postgres 17 marks a big leap ahead. It introduces extremely requested options like JSON_TABLE(), together with question features equivalent to JSON_EXISTS(), JSON_QUERY(), and JSON_VALUE(), and a wealthy new set of constructors for constructing JSON SQL objects.
