PostgreSQL 12 is taking shape; these are the most important new features

Door: Martijn Wallet 16-4-2019

Categorieën
:
Blog, Open Source, PostgreSQL, Review, Technology,

Each year there a new version of PostgreSQL is released. That’s the moment in which many new features and improvements become available for all users. During the last PostgreSQL meetup in Amsterdam, Devrim Gündüz, major contributor and passionate PostgreSQL consultant, explained the upcoming release of PostgreSQL 12. In this blog we list the most important changes in PostgreSQL 12 for everyone who does not closely follows all the commits in Github or who did’nt have the opportunity to visit the PostgreSQL Usergroup NL meetup.

blog_image:article_pagelo_15554237715cb5e21bb8fa3.png:end_blog_image

Enabling JIT by default

Pluggable storage

DOS prevention for some commands

Improved partitioning

Integration of recovery.conf in postgresql.conf

Other PostgreSQL performance improvements

Furthermore, there are many different small performance improvements and usability enhancements in the areas of psql and psql tab complete, SKIP_LOCKED for VACUUM, ANALYZE and vacuumdb options for xid and mxid. Too many to list. The complete overview can be found at: https://bit.ly/2VxWUF7

Conclusion

blog_image:article_pagelo_15554239805cb5e2ec7d031.jpg:end_blog_imageAll in all, there will be many great features in the coming release. PostgreSQL 12 Beta is expected to be available at the beginning of the summer. Until that time you can follow the development in the development version on GitHub. Do you want to know more about the new features of PostgreSQL and the practical implementation? Please contact us for information, or visit a PostgreSQL meetup or conference.

Back to blogoverview