PostgreSQL 11 New features
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/85986558> And triggers
* 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
* 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 !