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.pdfHewlett PackardEnterprise4.4 Parallel Merge Join /Gather Merge垂垂,垂垂垂垂垂垂,,垂垂垂,垂垂垂垂垂垂,垂垂,,垂垂垂垂垂垂,3.4.5 Parallel bitmap heap scan3.5 Archite443.5.1 Added Catalogs……3.5.2 Modi lied catalo513.5.3 Enhancement of libpq library.,…,…,…,…,…,…,…,…523.5.4 Changc from xlo to Wal533.5.5 Temporary replication slot3.5.6 Change instance startup le543.5. 7 WAL of hash index.553.5.8 Added role553.59 Custom Scan callback563.5.10 Size of wal file3.5.11ICU563.5.12 EUI-64 data ty565.13 Unique Joi563.5.14 Shared Memory Address573.6 Monitoring583. 6. 1 Monitor wait events583.6.2 EXPLAIN SUMMARY Statement583.6.3 VACUUM VERBOSE Statment3.7 Quorum-based synchronous replication3.8 Enhancement of Row Level Security...,…,,…,…623.8.1 Overview….623.8.2 Validation of multiple POlicy setting.623.9 Enhancement of sol statement663.9.1 UPDATE statement and row key word663.9.2 CREATE STATISTICS Statement639. 3 GENERATED AS IDENTITY column3.9 4ALTER TYPE Statement703.9.5 CREATE SEQUENCE Statement703.9.6 COPY Statement,.,…,…,,……………,713.9. 7 CREATE INDEX Statement713. 9. 8 CREATE TRIGGER Statement723.9.9 DROP FUNCTION Statement723.9.10 ALTER DEFAULT PRIVILEGE Statementc- 2017 Hewlett-Packard Enterprise Japan Co, LtdHewlett PackardEnterprise3.9.11 CREATE SERⅤ eR statement,,…………………………,733912 CREATE USER Statement3.9.13 Functions3.9.14 Procedural language.793.10 Change of configuration parameters.…,……813.10.1 Added parameters…,,…,…,…,…,…,…,…,…,…,…,…………,813.10.2 Changcd paramctcrs……23.10.3 Parameters with default values changed833.10.4 Deprecated parameters……843.10.5 New function of authentication method843.10.6 Default value of authentication setting853. 10. 7 Other parameter changc853.11 Change of utility3.11.1psql.…………………………………863.11.2 pg ctl.…….….……………3.11.3 pe baschackup…..883. 11. 4 pg dump913.11.5 pg dumpall……垂,垂垂中垂垂垂垂913. 11.6 pg recvlogical3. 11.7 pgbench92311.8 initdb923.11.g pg receivexlo923. 11.10 pg restore3.11.llpg_ upgrade……………,……,…923.11.12 createuser933. 11.13 createlang /droplang933.12 Contrib modules943. 12. 1 postgres fdw943. 12.2 file fdw953. 123 amchcck963. 12.4 pageinspect963.12.5 pgstatluple....,.,,,…,…,973. 12.6 btree gist /btree gin973. 12.7 pg stat statements98312. 8 tsearch98URL list99c- 2017 Hewlett-Packard Enterprise Japan Co, LtdHewlett PackardEnterpriseChange history…垂垂,垂垂垂垂垂垂,,垂垂垂,垂垂垂垂垂垂,垂垂,,垂垂,垂垂。。,。新c- 2017 Hewlett-Packard Enterprise Japan Co, LtdHewlett PackardEnterprise1. About this document1. PurposeThe purpose of this document is to provide information of the major new features of Postgre SQL 10,the Beta 1 version being published12 AudienceThis document is written for engineers who already have knowledge of PostgreSQL, such asinstallation, basic management, elc1.3 ScopeThis document describes the major difference between PostgreSQL 9.6 and postgreSQL 10 Beta IAs a general rule, this document examines the functions that users can see when they see changes. Itdoes not describe and verify all new features. In particular, the following new functions are notincluded● Bug fixPerformance improvement by changing internal behaviorImprovement of regression testOperability improvement by psql command tab inputImprovement of pgbench command (partly dcscribed)Improve documentation, modify typo in the sources1. 4 Software versionThis document is being verified for the following versions and platformsTable l versionSoftwareVersionsPostgrcSoiPostgresQL 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 ResponsibilityThe contents of this document are not an official opinion of the hewlett-Packard Enterprise JapanCo, Ltd. The author and affiliation company do not take any responsibility about the problem causedy the mistake of contents. If you have any comments for this document, please contact to noriyoshiShinoda (noriyoshi. shinoda(ahpc. com) Hcwlctt-Packard Entcrprisc Japan Co, Ltdc- 2017 Hewlett-Packard Enterprise Japan Co, Ltd6Hewlett PackardEnterprise1.6 NotationThis document contains examples of the execution of the command or SQL statement. Executionexamples are described according to the following rulesTable 2 Examples notationNotationDescriptionShell prompt for Linux root userShell prompt for linux general userboldUSer input stringpostgres=# psqI command prompt for PostgreSQL administratorpostgres=> psql command prompt for PostgreSQL general userunderline Important output itemsThe syntax is dcscribed in the following rulcsTable 3 Syntax rulesNotation DescriptionItalicReplaced 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 BGeneral syntax, it is the same as the previous versionc- 2017 Hewlett-Packard Enterprise Japan Co, Ltd7Hewlett PackardEnterprise2. Version notationThe notation of major version and minor version is changed from PostgreSQL 10. In the past, thefirst two numbers indicated major versions, but only the first number will indicate the major versionin the fulureFigure 1 Version notationold version (9.6 is major version, 1 is minor version)6From now on(10 is major version, 0 is minor version)16c- 2017 Hewlett-Packard Enterprise Japan Co, Ltd8Hewlett PackardEnterprise3. New features3.0ν ervinMore than 100 new features have been added to Postgre SQL 10. Here are some typical new featuresand benefits3.1.1 For large amount dataNative partition TableNative Partition Table is provided as a method of physically partitioning a large scale table. Unliketable partitioning using conventional inheritance tablc, pcrformance during data insertion has bccngreatly improved. Providing the Native Partition Table makes building a large database easier口 Logical replicationWith the Logical Replication feature. it is possible to replicate only some tables between multipleinstances. In traditional streaming replication slave sidc instances were rcad- only. but tablessynchronized by logical Replication are updatable. Therefore, it is possible to create an index foranalysis query to the slave side instance. Details are described in 3.3 Logical Replicationa Enhancement of Parallel queryIn PostgreSQL 9.6, a parallel query feature was provided to improve the query performance for largetables. Parallel query was used only in"Seq Scan"in PostgreSQL 9.6, but parallel queries are nowavailable in many situations such as"Index Scan", " Merge Join","Bitmap Join"and so on. It isexpected to improve query performance for large amount tables. Details are described in"3. 4 ExtendedParallcl Query3.1.2 For reliability improvementQuorum-based synchronous replication for arbitrarily selecting instances for synchronous replicationis now available (3.7 Quorum-base synchronous replication). Hash index that did not output WALbefore PostgreSQL 9.6 now output WAL. For this reason, hash index is also available in replicationenvironments(3.5.7 Hash indeX WAL)c- 2017 Hewlett-Packard Enterprise Japan Co, LtdHewlett PackardEnterprise3.1.3 For maintenance taskWait events that are output in the pg stat activity catalog has been increased significantlyInformation of all backend processes can now be referred (3.5.2 catalog change). a dedicated role tocheck the system load has been added (3.5.8 Addition of role3.1.4 IncompatibilityUnfortunately, some features of PostgreSQL 10 are incompatible with previous versions口 Change nameAll 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 havcbeen changed. For example, the pg xlog directory in the database cluster has been changed to thepg wal directory. The pg receivexlog command has been changed to the pg receivewal commandThe default value of the directory where the log file is output has been changed from pg log to logDetails arc dcscribed in 3.5.4 Changc from XloG to Walla Default behavior of pg basebackup utilityBy default WaL streaming is used in PostgreSQL 10. Also, the-x parameter has been deprecatedDetails are described in3. 11.3 pg basebackupa Wait mode of pg ctl utilityBy defaull, the behavior has been changed to wait for processing to complete on all operationsthe previous version, pg ctl command did not wait for the completion of processing in instance startupprocessing etc. Details are described in3. 11.2 pg ctl"a Deprecated of plain password storeIt is no longer possible to save the password without encrypting it This will improve security detailsare described in3.9 12 CREATE USER statement "and"3. 10.2 Changed parametersa Deprecated parametersThe parameter min parallel relation size has been changed Lo min parallel table scan size. Theparameter sql inheritance has been deprecated. Details are described in3.10. 4 Obsolete parametersc- 2017 Hewlett-Packard Enterprise Japan Co, Ltd10