September's CommitFest for version 18 has seen a wealth of accepted patches and new features, including:
- Conflict detection and logging in logical replication
- Removal of the constant 10000000000 in the planner to improve sequential scan cost assessment
- Enhanced memory management and usage monitoring for temporary tuple storage
- Asynchronous operations support in pg_upgrade for multiple databases
- Speed improvements for Hash Joins
- Faster text value processing in JSON
- Optimized numeric-type multiplication and division
- Introduction of ANALYZE ONLY and VACUUM ONLY commands
- Improved checkpointer statistics
- Normalization of SET commands in pg_stat_statements
- Reporting of remote connection status in postgres_fdw_get_connections
- Ignoring format conversion errors in file_fdw
- New function has_largeobject_privilege
- Functions crc32 and crc32c added
- Client-server protocol updates to report search_path changes
- Support for named prepared statements in psql
- Integrity verification for tar backups in pg_verifybackup