Top New Features in PostgreSQL 15 database

Postgres 15 new features

PostgreSQL 15 has many improvements and new features.

• MERGE command has been introduced.
• Added support for Zstandard (zstd) compression. E.g. allow WAL full-page writes to use LZ4 and Zstandard compression.
• Prevent logical replication of empty transactions.
• Add SQL functions to monitor the directory contents of logical replication slots, new functions are pg_ls_logicalsnapdir(), pg_ls_logicalmapdir(), and pg_ls_replslotdir().
• Performance improvements, particularly for in-memory and on-disk sorting.
• New pg_database_owner role.
• New wait events are used when calling archive_command, archive_cleanup_command, restore_command and recovery_end_command.
• Add predefined role pg_checkpoint that allows members to run CHECKPOINT.
• Subscribers can stop the application of logical replication changes on error, with the option disable_on_error.
• Add support for petabyte units to pg_size_pretty() and pg_size_bytes().

New System Views in Postgres 15:

• Add system view pg_ident_file_mappings to report pg_ident.conf information.
• Add system view pg_stat_subscription_stats to report on subscriber activity. And new function pg_stat_reset_subscription_stats() allows resetting these statistics counters.

New Parameters in PostgreSQL 15:

• Add server variable recursive_worktable_factor to allow the user to specify the expected size of the working table of a recursive query.
• New server variable log_startup_progress_interval - to generate progress messages in the server log during slow server starts.
• Add server variable shared_memory_size to report the size of allocated shared memory.
• Add server variable shared_memory_size_in_huge_pages to report the number of huge memory pages required.

Removed:

• Python 2.x is no longer supported.

Related PostgreSQL Articles:  New Features in PostgreSQL 14 database   Postgres 13 new features