PostgreSQL Global development team estimates 2018 Release the latest PosgtreSQL Release
11. In the official release notes , The new features and enhancements brought by this version are introduced .

PostgreSQL 11 The following functions are mainly enhanced :

* Partition enhancement
* Support hash partition <https://mp.csdn.net/postedit/85775084>.
* Supports primary keys on partitioned tables <https://mp.csdn.net/postedit/85986558>, Foreign key
<https://mp.csdn.net/postedit/86063403>, Indexes
<https://mp.csdn.net/postedit/85986558> And triggers
<https://mp.csdn.net/postedit/86085948>.
* Support the creation of default partitions <https://mp.csdn.net/postedit/86076038>, Used to store data that does not belong to any other partition .
* Update partition key values <https://mp.csdn.net/postedit/86084535> Of UPDATE Statement to move the affected rows to the corresponding new partition .
* Enhanced query statement processing and execution of partition clipping <https://blog.csdn.net/horses/article/details/86143763>
( Partition exclusion ), And then improved SELECT Performance of query statements .
* Support intelligent partition connection <https://blog.csdn.net/horses/article/details/86164273>
(partition-wise join) And intelligent partition aggregation
<https://blog.csdn.net/horses/article/details/86164273>(partition-wise
aggregation).
* Parallel execution
* Parallel creation B-tree Indexes .
* Parallel execution CREATE TABLE .. AS,CREATE MATERIALIZED VIEW And specific UNION query .
* Better parallel hash join and parallel sequential scan .
* stored procedure <https://blog.csdn.net/horses/article/details/83538832>, Support embedded transactions .
* Just in time compilation (JIT), Supports fast evaluation of expressions .
* Window function , support SQL:2011 All window ranges in the standard (window frame) option , include RANGE distance
PRECEDING/FOLLOWING,GROUPS Mode and window exclusion options .
* Overlay index <https://blog.csdn.net/horses/article/details/85603584>(covering
index), Support the use of CREATE INDEX ... INCLUDE Create overlay index .
* Many other performance improvements , Include quick execution with non empty default value <https://mp.csdn.net/postedit/85707488> Of ALTER TABLE
.. ADD COLUMN sentence .
For a complete introduction, please refer to the official release notes <https://www.postgresql.org/docs/11/static/release-11.html>.

Life is short , Why are you in a hurry ! Please give me a compliment before you go !