🎉 PostgreSQL 14 has been released today.
The amount of new features EVERY YEAR is incredible and there are again many nice features greatly improving your daily life. Most important this year is JSONB!
👇 Keep reading for an overview of the most important features.
The amount of new features EVERY YEAR is incredible and there are again many nice features greatly improving your daily life. Most important this year is JSONB!
👇 Keep reading for an overview of the most important features.
👉Improved JSONB
If you never stored any JSON content in your tables you are definitely missing out on some very great features of PostgreSQL. From now on, you can use an improved syntax with much simpler support for updating nested values. postgresql.org/docs/14/dataty…
If you never stored any JSON content in your tables you are definitely missing out on some very great features of PostgreSQL. From now on, you can use an improved syntax with much simpler support for updating nested values. postgresql.org/docs/14/dataty…
👉Multirange Types
Range Types have always been a fantastic feature of PostgreSQL and I totally fell in love with them. You can now store multiple ranges within one column and use the extensive range operators for querying.
postgresql.org/docs/14/ranget…
postgresql.org/docs/14/functi…
Range Types have always been a fantastic feature of PostgreSQL and I totally fell in love with them. You can now store multiple ranges within one column and use the extensive range operators for querying.
postgresql.org/docs/14/ranget…
postgresql.org/docs/14/functi…
👉Date Binning
This may look like a small feature, but I have implemented it so often in the past. I am thrilled it's now in the core. Like truncing with date_trunc() to a specified precision, you can now bin the date to a completely custom interval. postgresql.org/docs/14/functi…
This may look like a small feature, but I have implemented it so often in the past. I am thrilled it's now in the core. Like truncing with date_trunc() to a specified precision, you can now bin the date to a completely custom interval. postgresql.org/docs/14/functi…
👉SEARCH/CYCLE
Recursive queries are a powerful but lesser known feature. They have now been improved with the ability to specify depth-first or breadth-first search. And cycle detection will prevent you from doing infinite recursion. postgresql.org/docs/14/querie…
Recursive queries are a powerful but lesser known feature. They have now been improved with the ability to specify depth-first or breadth-first search. And cycle detection will prevent you from doing infinite recursion. postgresql.org/docs/14/querie…
👉 LZ4 compression for TOAST values (much faster, slight more used space)
👉 Improvements for handling large number of connections
👉 Smaller B-Tree bloat
👉 pg_read_all_data/pg_write_all_data for backup/restore and monitoring apps
And many more... postgresql.org/docs/release/1…
👉 Improvements for handling large number of connections
👉 Smaller B-Tree bloat
👉 pg_read_all_data/pg_write_all_data for backup/restore and monitoring apps
And many more... postgresql.org/docs/release/1…
If you enjoyed reading this summary of the most important PostgreSQL 14 innovations, feel free to follow me. I regularly share database news, knowledge and tips & tricks.
• • •
Missing some Tweet in this thread? You can try to
force a refresh
