2020-01-12 21:28:28 -05:00
|
|
|
Version 10 Features
|
|
|
|
|
===================
|
|
|
|
|
|
|
|
|
|
Auto Logging [blog](http://databasedoings.blogspot.com/2017/07/cool-stuff-in-postgresql-10-auto-logging.html)
|
|
|
|
|
|
|
|
|
|
Transition Tables [blog](http://databasedoings.blogspot.com/2017/07/cool-stuff-in-postgresql-10-transition.html)
|
|
|
|
|
|
|
|
|
|
Correlated Columns Query Plan [blog](https://blog.2ndquadrant.com/pg-phriday-crazy-correlated-column-crusade/)
|
|
|
|
|
|
|
|
|
|
Native Partitioning
|
|
|
|
|
|
|
|
|
|
Logical Replication
|
|
|
|
|
|
|
|
|
|
Add a version of jsonb's delete operator that takes an array of keys to delete (Magnus Hagander)
|
|
|
|
|
|
|
|
|
|
Make json_populate_record() and related functions process JSON arrays and objects recursively (Nikita Glukhov)
|
|
|
|
|
|
|
|
|
|
Identity Columns [blog](https://blog.2ndquadrant.com/postgresql-10-identity-columns/)
|
|
|
|
|
|
|
|
|
|
Add view pg_hba_file_rules to display the contents of pg_hba.conf (Haribabu Kommi)
|
|
|
|
|
|
|
|
|
|
Add XMLTABLE function that converts XML-formatted data into a row set (Pavel Stehule, Álvaro Herrera)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Security
|
|
|
|
|
===================
|
|
|
|
|
|
|
|
|
|
LDAP & Active Directory [blog](https://www.openscg.com/2017/07/setting-up-ldap-with-active-directory-in-postgresql/)
|
|
|
|
|
|
|
|
|
|
Add SCRAM-SHA-256 support for password negotiation and storage (Michael Paquier, Heikki Linnakangas)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Monitoring
|
|
|
|
|
====================
|
|
|
|
|
|
|
|
|
|
file system info - [pg_stat_kcache](https://rjuju.github.io/postgresql/2018/07/17/pg_stat_kcache-2-1-is-out.html)
|
