This new function additionally introduces a extra environment friendly methodology of merging incremental backups offline into full backups, lowering the server load usually 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 function features a strong set of hooks that allow storage to many various targets, in addition to assist for options like compression and tarball storage.
New in-core backup performance means quicker restoration occasions, lowering restoration time targets (RTO) dramatically—a vital requirement for enterprises working massive databases or high-availability programs. This makes Postgres an much more enticing choice for organizations the place downtime has important enterprise impacts, comparable 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 commonplace, offering database builders with a robust set of features for interacting with JSON paperwork in a manner that feels pure to these acquainted with SQL. Postgres has been regularly 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 comparable to JSON_EXISTS(), JSON_QUERY(), and JSON_VALUE(), and a wealthy new set of constructors for constructing JSON SQL objects.
