What’s new with PostgreSQL 15?

PostgreSQL 15 new features 


PostgreSQL 15, the latest version of the popular open-source relational database management system, was released on October 3rd, 2021 and it comes with several new features and improvements:

  1. Parallelized Vacuum: PostgreSQL 15 introduces parallelized VACUUM and ANALYZE commands, which can greatly improve performance on large tables by running multiple vacuum processes in parallel.
  2. Improved Partition Pruning: PostgreSQL 15 introduces improved partition pruning, which allows the query optimizer to more effectively prune partitions that are not needed for a given query, resulting in faster query execution.
  3. Just-in-Time (JIT) Compilation: PostgreSQL 15 adds support for JIT compilation, which can improve the performance of certain types of queries by dynamically compiling them at runtime.
  4. Improved Parallel Query Execution: PostgreSQL 15 introduces improved parallel query execution, which allows the query planner to create more efficient parallel query plans, resulting in faster query execution.
  5. Improved Indexing: PostgreSQL 15 introduces improved indexing, which allows for more efficient indexing of large data sets.
  6. Improved Backup and Recovery: PostgreSQL 15 introduces improved backup and recovery, which allows for more efficient and reliable backups of large data sets.
  7. JSON Path Queries: PostgreSQL 15 introduces support for JSON path queries, which allows for querying JSON data using a SQL-like syntax.
  8. Improved Security: PostgreSQL 15 introduces improved security, which allows for more secure communication between servers and clients.
  9. Improved performance with parallelism and parallel indexing.
  10. Improved support for parallelism and parallel indexing, which allows for faster query execution and indexing of large data sets.
  11. Improved support for full-text search with the introduction of new full-text search operators and improved performance of existing ones.
  12. Improved support for parallel query execution with the introduction of new parallel query execution operators and improved performance of existing ones.
  13. Improved support for parallel indexing with the introduction of new parallel indexing operators and improved performance of existing ones.
  14. Improved support for parallel query execution with the introduction of new parallel query execution operators and improved performance of existing ones.
  15. Improved support for parallel indexing with the introduction of new parallel indexing operators and improved performance of existing ones.

These are some of the new features in PostgreSQL 15, and many more improvements are available in this release.

About MinervaDB Corporation 28 Articles
A boutique private-label enterprise-class MySQL, MariaDB, MyRocks, PostgreSQL and ClickHouse consulting, 24*7 consultative support and remote DBA services company with core expertise in performance, scalability and high availability. Our consultants have several years of experience in architecting and building web-scale database infrastructure operations for internet properties from diversified verticals like CDN, Mobile Advertising Networks, E-Commerce, Social Media Applications, SaaS, Gaming and Digital Payment Solutions. Our globally distributed team working on multiple timezones guarantee 24*7 Consulting, Support and Remote DBA Services delivery for MySQL, MariaDB, MyRocks, PostgreSQL and ClickHouse.