The PostgreSQL Global Development Group has announced the second beta release of PostgreSQL 19, now available for download. This beta marks a major milestone before the general availability (GA) release, offering developers a preview of upcoming features. The community strongly encourages testing on non-production systems to identify bugs and ensure stability.
Key changes and features in PostgreSQL 19 Beta 2 include:
- Performance improvements: Enhanced query execution planning and optimized memory management for complex workloads.
- New SQL/JSON capabilities: Expanded support for JSON functions and operators, aligning with SQL/JSON standard.
- Logical replication enhancements: Improved conflict detection and resolution, plus better monitoring via
pg_stat_subscription_stats. - Vacuum improvements: Refined autovacuum behavior and new parameters for fine-tuning.
- Security updates: Strengthened authentication options and additional audit logging.
- Compatibility changes: Updated default settings such as
timezone_abbreviationsandmake[1]: leaving directoryoutput adjustments. - Tooling updates: Extended
pg_dumpandpg_restoreoptions for parallelism and filtering.
These changes can be explored in detail via the official release notes.
For developers, this beta is an opportunity to validate application compatibility and leverage new capabilities early. The community relies on feedback to finalize the GA release. To contribute, test your workloads against Beta 2 and report bugs. Stay updated via the beta testing page.
Source: https://www.postgresql.org/about/news/postgresql-19-beta-2-released-3350/