下载  >  数据库  >  PostgreSQL  > PostgreSQL 10 New Features en

PostgreSQL 10 New Features en 评分

附件来自:http://h50146.www5.hpe.com/products/software/oe/linux/mainstream/support/lcc/pdf/PostgreSQL_10_New_Features_en_20170522-1.pdf
Hewlett Packard Enterprise 4.4 Parallel Merge Join /Gather Merge 垂垂,垂垂垂垂垂垂,,垂垂垂,垂垂垂垂垂垂,垂垂,,垂垂垂垂垂垂, 3.4.5 Parallel bitmap heap scan 3.5 Archite 44 3.5.1 Added Catalogs…… 3.5.2 Modi lied catalo 51 3.5.3 Enhancement of libpq library.,…,…,…,…,…,…,…,… 52 3.5.4 Changc from xlo to Wal 53 3.5.5 Temporary replication slot 3.5.6 Change instance startup le 54 3.5. 7 WAL of hash index .55 3.5.8 Added role 55 3.59 Custom Scan callback 56 3.5.10 Size of wal file 3.5.11ICU 56 3.5.12 EUI-64 data ty 56 5.13 Unique Joi 56 3.5.14 Shared Memory Address 57 3.6 Monitoring 58 3. 6. 1 Monitor wait events 58 3.6.2 EXPLAIN SUMMARY Statement 58 3.6.3 VACUUM VERBOSE Statment 3.7 Quorum-based synchronous replication 3.8 Enhancement of Row Level Security...,…,,…,… 62 3.8.1 Overview…. 62 3.8.2 Validation of multiple POlicy setting .62 3.9 Enhancement of sol statement 66 3.9.1 UPDATE statement and row key word 66 3.9.2 CREATE STATISTICS Statement 6 39. 3 GENERATED AS IDENTITY column 3.9 4ALTER TYPE Statement 70 3.9.5 CREATE SEQUENCE Statement 70 3.9.6 COPY Statement,.,…,…,,……………,71 3.9. 7 CREATE INDEX Statement 71 3. 9. 8 CREATE TRIGGER Statement 72 3.9.9 DROP FUNCTION Statement 72 3.9.10 ALTER DEFAULT PRIVILEGE Statement c- 2017 Hewlett-Packard Enterprise Japan Co, Ltd Hewlett Packard Enterprise 3.9.11 CREATE SERⅤ eR statement,,…………………………,73 3912 CREATE USER Statement 3.9.13 Functions 3.9.14 Procedural language .79 3.10 Change of configuration parameters.…,……81 3.10.1 Added parameters…,,…,…,…,…,…,…,…,…,…,…,…………,81 3.10.2 Changcd paramctcrs…… 2 3.10.3 Parameters with default values changed 83 3.10.4 Deprecated parameters…… 84 3.10.5 New function of authentication method 84 3.10.6 Default value of authentication setting 85 3. 10. 7 Other parameter changc 85 3.11 Change of utility 3.11.1psql.………………………………… 86 3.11.2 pg ctl.…….….…………… 3.11.3 pe baschackup… ..88 3. 11. 4 pg dump 91 3.11.5 pg dumpall…… 垂,垂垂中垂垂垂垂 91 3. 11.6 pg recvlogical 3. 11.7 pgbench 92 311.8 initdb 92 3.11.g pg receivexlo 92 3. 11.10 pg restore 3.11.llpg_ upgrade……………,……,… 92 3.11.12 createuser 93 3. 11.13 createlang /droplang 93 3.12 Contrib modules 94 3. 12. 1 postgres fdw 94 3. 12.2 file fdw 95 3. 123 amchcck 96 3. 12.4 pageinspect 96 3.12.5 pgstatluple....,.,,,…,…,97 3. 12.6 btree gist /btree gin 97 3. 12.7 pg stat statements 98 312. 8 tsearch 98 URL list 99 c- 2017 Hewlett-Packard Enterprise Japan Co, Ltd Hewlett Packard Enterprise Change history… 垂垂,垂垂垂垂垂垂,,垂垂垂,垂垂垂垂垂垂,垂垂,,垂垂,垂垂。。,。新 c- 2017 Hewlett-Packard Enterprise Japan Co, Ltd Hewlett Packard Enterprise 1. About this document 1. Purpose The purpose of this document is to provide information of the major new features of Postgre SQL 10, the Beta 1 version being published 12 Audience This document is written for engineers who already have knowledge of PostgreSQL, such as installation, basic management, elc 1.3 Scope This document describes the major difference between PostgreSQL 9.6 and postgreSQL 10 Beta I As a general rule, this document examines the functions that users can see when they see changes. It does not describe and verify all new features. In particular, the following new functions are not included ● Bug fix Performance improvement by changing internal behavior Improvement of regression test Operability improvement by psql command tab input Improvement of pgbench command (partly dcscribed) Improve documentation, modify typo in the sources 1. 4 Software version This document is being verified for the following versions and platforms Table l version Software Versions PostgrcSoi PostgresQL 9.6.3(for comparison) PostgreSQL 10 Beta I(May 15, 201721: 27: 43) Operating System Red Hat Enterprise Linux 7 Update 1(x86-64) 1.5 Question, Comment, and Responsibility The contents of this document are not an official opinion of the hewlett-Packard Enterprise Japan Co, Ltd. The author and affiliation company do not take any responsibility about the problem caused y the mistake of contents. If you have any comments for this document, please contact to noriyoshi Shinoda (noriyoshi. shinoda(ahpc. com) Hcwlctt-Packard Entcrprisc Japan Co, Ltd c- 2017 Hewlett-Packard Enterprise Japan Co, Ltd 6 Hewlett Packard Enterprise 1.6 Notation This document contains examples of the execution of the command or SQL statement. Execution examples are described according to the following rules Table 2 Examples notation Notation Description Shell prompt for Linux root user Shell prompt for linux general user bold USer input string postgres=# psqI command prompt for PostgreSQL administrator postgres=> psql command prompt for PostgreSQL general user underline Important output items The syntax is dcscribed in the following rulcs Table 3 Syntax rules Notation Description Italic Replaced by the name of the object which users use, or the other syntax [ABC Indicate that it can be milled ( B) Indicate that it is possible to select A or B General syntax, it is the same as the previous version c- 2017 Hewlett-Packard Enterprise Japan Co, Ltd 7 Hewlett Packard Enterprise 2. Version notation The notation of major version and minor version is changed from PostgreSQL 10. In the past, the first two numbers indicated major versions, but only the first number will indicate the major version in the fulure Figure 1 Version notation old version (9.6 is major version, 1 is minor version) 6 From now on(10 is major version, 0 is minor version) 16 c- 2017 Hewlett-Packard Enterprise Japan Co, Ltd 8 Hewlett Packard Enterprise 3. New features 3.0ν ervin More than 100 new features have been added to Postgre SQL 10. Here are some typical new features and benefits 3.1.1 For large amount data Native partition Table Native Partition Table is provided as a method of physically partitioning a large scale table. Unlike table partitioning using conventional inheritance tablc, pcrformance during data insertion has bccn greatly improved. Providing the Native Partition Table makes building a large database easier 口 Logical replication With the Logical Replication feature. it is possible to replicate only some tables between multiple instances. In traditional streaming replication slave sidc instances were rcad- only. but tables synchronized by logical Replication are updatable. Therefore, it is possible to create an index for analysis query to the slave side instance. Details are described in 3.3 Logical Replication a Enhancement of Parallel query In PostgreSQL 9.6, a parallel query feature was provided to improve the query performance for large tables. Parallel query was used only in"Seq Scan"in PostgreSQL 9.6, but parallel queries are now available in many situations such as"Index Scan", " Merge Join","Bitmap Join"and so on. It is expected to improve query performance for large amount tables. Details are described in"3. 4 Extended Parallcl Query 3.1.2 For reliability improvement Quorum-based synchronous replication for arbitrarily selecting instances for synchronous replication is now available (3.7 Quorum-base synchronous replication). Hash index that did not output WAL before PostgreSQL 9.6 now output WAL. For this reason, hash index is also available in replication environments(3.5.7 Hash indeX WAL) c- 2017 Hewlett-Packard Enterprise Japan Co, Ltd Hewlett Packard Enterprise 3.1.3 For maintenance task Wait events that are output in the pg stat activity catalog has been increased significantly Information of all backend processes can now be referred (3.5.2 catalog change). a dedicated role to check the system load has been added (3.5.8 Addition of role 3.1.4 Incompatibility Unfortunately, some features of PostgreSQL 10 are incompatible with previous versions 口 Change name All the name XloG was unified to WAL. For this reason, directory names in the database cluster. utility command namcs, function namcs, paramctcr namcs, and crror messages namcd XLOG havc been changed. For example, the pg xlog directory in the database cluster has been changed to the pg wal directory. The pg receivexlog command has been changed to the pg receivewal command The default value of the directory where the log file is output has been changed from pg log to log Details arc dcscribed in 3.5.4 Changc from XloG to Wall a Default behavior of pg basebackup utility By default WaL streaming is used in PostgreSQL 10. Also, the-x parameter has been deprecated Details are described in3. 11.3 pg basebackup a Wait mode of pg ctl utility By defaull, the behavior has been changed to wait for processing to complete on all operations the previous version, pg ctl command did not wait for the completion of processing in instance startup processing etc. Details are described in3. 11.2 pg ctl" a Deprecated of plain password store It is no longer possible to save the password without encrypting it This will improve security details are described in3.9 12 CREATE USER statement "and"3. 10.2 Changed parameters a Deprecated parameters The parameter min parallel relation size has been changed Lo min parallel table scan size. The parameter sql inheritance has been deprecated. Details are described in3.10. 4 Obsolete parameters c- 2017 Hewlett-Packard Enterprise Japan Co, Ltd 10

...展开详情
所需积分/C币:1 上传时间:2018-05-26 资源大小:2.07MB
举报 举报 收藏 收藏
分享 分享
PostgreSQL 10 New Features en

附件来自:http://h50146.www5.hpe.com/products/software/oe/linux/mainstream/support/lcc/pdf/PostgreSQL_10_New_Features_en_20170522-1.pdf

立即下载
Learning PostgreSQL 10

ASIN: B077NQGV1G, ISBN: 1788392019 Year: 2017 Format: AZW3 Pages: 488 pages Leverage the power of PostgreSQL 10 to build powerful database and data warehousing applications. About This Book Be introduced to the concept of relational databases and PostgreSQL, one of the fastest growing open sour

立即下载
Mastering PostgreSQL 10 Expert techniques on PostgreSQL 10 development and epub

Mastering PostgreSQL 10 Expert techniques on PostgreSQL 10 development and administration 英文epub 本资源转载自网络,如有侵权,请联系上传者或csdn删除 查看此书详细信息请在美国亚马逊官网搜索此书

立即下载
PostgreSql10 ODBC驱动

PostgreSQL10在windows 64位下面的最新ODBC驱动

立即下载
postgresql 10.2

postgresql 10.2 下载,,,,,,,,,,,,,,,,

立即下载
postgreSQL10.1

破解版PostgreSql 10.1安装文件Please see the manual archive for documentation for older releases. The DocBook SGML source for the manuals is available as part of the PostgreSQL source download available in the FTP area.

立即下载
PostgreSQL 10官方手册

最权威的、最详细的中文PostgreSQL手册,可以更深入了解PostgreSQL数据库

立即下载
PostgreSQL 10 High Performance

Table of Contents Chapter 1. PostgreSQL Versions Chapter 2. Database Hardware Chapter 3. Database Hardware Benchmarking Chapter 4. Disk Setup Chapter 5. Memory for Database Caching Chapter 6. Server Configuration Tuning Chapter 7. Routine Maintenance Chapter 8. Database Benchmarking Chapter 9. Datab

立即下载
PostgreSQL 10 Administration Cookbook源码

PostgreSQL 10 Administration Cookbook 书涉及源码分享

立即下载
PostgreSQL 10手册.pdf

最新、最权威PostgreSQL中文手册、PostgreSQL10.1中文文档、共2945页pdf版,欢迎下载交流

立即下载
Navicat For Postgresql 10 绿色

Navicat For Postgresql 10 绿色 解压后有码输入一下就可以

立即下载
postgresql10的帮助文档

postgresql10的帮助文档,PDF文档,比网上阅读效率更高

立即下载
postgresql

postgresql

立即下载
PostgreSQL 10 DBA菜谱源码

书籍PostgreSQL 10 Administration Cookbook中对书中例子进行学习中用到的SQL源代码,此代码源自packthub/mapt,为公开共享资源

立即下载
postgresql 10.1 手册

postgresql 官网git下载的 中文源码编译的pdf 说明手册

立即下载
ModbusTCP/RTU网关设计

基于UIP协议栈,实现MODBUS联网,可参考本文档资料,有MODBUS协议介绍

立即下载
html+css+js制作的一个动态的新年贺卡

该代码是http://blog.csdn.net/qq_29656961/article/details/78155792博客里面的代码,代码里面有要用到的图片资源和音乐资源。

立即下载
iCopy解码软件v1.0.1.7.exe

解ic,id,hid卡密码破解ic,id,hid卡密码破解ic,id,hid破解ic,id,hid卡破解ic,id,hid卡密码密码卡密码破解ic,id,hid卡...

立即下载
分布式服务框架原理与实践(高清完整版)

第1章应用架构演进1 1.1传统垂直应用架构2 1.1.1垂直应用架构介绍2 1.1.2垂直应用架构面临的挑战4 1.2RPC架构6 1.2.1RPC框架原理6 1.2.2最简单的RPC框架实现8 1.2.3业界主流RPC框架14 1.2.4RPC框架面临的挑战17 1.3SOA服务化架构18 1.3.1面向服务设计的原则18 1.3.2服务治理19 1.4微服务架构21 1.4.1什么是微服务21 1.4.2微服务架构对比SOA22 1.5总结23 第2章分布式服务框架入门25 2.1分布式服务框架诞生背景26 2.1.1应用从集中式走向分布式.26?

立即下载
Camtasia 9安装及破解方法绝对有效

附件中注册方法亲测有效,加以整理与大家共享。 由于附件大于60m传不上去,另附Camtasia 9百度云下载地址。免费自取 链接:http://pan.baidu.com/s/1kVABnhH 密码:xees

立即下载