Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i4ptp-0004Ja-8J for pgsql-advocacy@arkaria.postgresql.org; Mon, 02 Sep 2019 17:13:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1i4ptn-0004FA-By for pgsql-advocacy@arkaria.postgresql.org; Mon, 02 Sep 2019 17:13:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i4ptn-0004Dt-2v for pgsql-advocacy@lists.postgresql.org; Mon, 02 Sep 2019 17:13:51 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i4ptk-00028K-7t for pgsql-advocacy@lists.postgresql.org; Mon, 02 Sep 2019 17:13:50 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:MIME-Version:Date: Message-ID:From:References:Cc:To:Subject:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=ZK6VYasgoBILETecxMGjMjxHTZyOxa/bhgoz9Xf2SDo=; b=kiU5lAhiyyt/VzgH+eDTMnjAra enjWYpzM11Y/vSHxzeedq2yNWheZWVlufsW3CkDSybA9PgBCwI056BTHbpVQHgEVQx3gjttIGKnOI oRCtEtrg9Cf7e+R8QVZzbYBvS0TWp4WokTycEd33We+eEYIXOfcKFzE/C9YJSOip0pOHk9DWH8ckx yCMEDeMHUYl3iYq1yn4UK2fw6sDF9W/ijTxDyPRHD0EpF71l3b9aZhz539ELI7T4PDB3WLxHupKHQ nkGdu1zVVT2H52Fvzmk/LDO9AGoH3K7StZFk1aXqOgCZvFVgade1EdExhEUb6yd7Cy+Gdq/fgAQkd TWNY/HVg==; Received: from pool-173-77-254-165.nycmny.fios.verizon.net ([173.77.254.165] helo=Ph33r-Retina.home) by meldrar.postgresql.org with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i4ptg-0003Q3-Na; Mon, 02 Sep 2019 17:13:48 +0000 Subject: Re: PostgreSQL 12 Press Release - First Draft To: Erik Rijkers Cc: Peter Eisentraut , PostgreSQL Advocacy References: <0736c146-d9a1-b5e3-4290-866dee8ed2d5@2ndquadrant.com> From: "Jonathan S. Katz" Openpgp: preference=signencrypt Autocrypt: addr=jkatz@postgresql.org; keydata= mQINBFtShwABEAC7PNHDUOTYuifpUCk23KqfxdQQkn4nkoxOXRK0+rAj36FiwqGB4TJFuOVZ sDFAEiSlC8Jt4y5Cs7B5tetT8JNd2cs6zp/udMJJDz9d65O9PDpdlMgAmIiTzpLlSdx8FG56 DTksaDv1d8j3cTJPSE4/fWSxqzA7o3Y9UuL7atZPrzfImgpRKs0of7elIHwOa8GucjyhYqcR h60wFBJc2KXqQdDYRTZy43DSnY/0VNc0omiH355fustvpm+m5HjD3w7qZyfN3fpKJpnX1LCF f3MnPHaDGITIYGRCBXvf0UqUtD6OEVWPv2C2gyqWMIpWmZTOgDufltKyIByKBoS9x0PlFkij 04X3KODCngt+N8Ssc9OICc6QSxhjoP48PYPdmiTmkrGuf0LX084wj1xeo1NX7XxZK39F6dTJ DhsIiW0sNS0xMxQHLHG9VLbPjx3SANQBh6BuryPz5ZupW9/TIDmkvprtU/oXfKgtfYm3fxmk EctxbWrEPsFTFPyuMqQu6l+xyQv0s1VLZfjNWaua6H1/gGoIt6kRnn5qMXDVVpijuWkHbv7G ngaQMd258UrrOEHnnjzhQ7jxMWV9D+emxbAtlIxnYvCWlV4IwAQhEHfvudqYaIY3hNWrvQ6H GB2KXoTZYN9g5djm14/5nj1IU5zOcovkjJnKhoo9iStnpFF2cwARAQABtCdKb25hdGhhbiBT LiBLYXR6IDxqa2F0ekBwb3N0Z3Jlc3FsLm9yZz6JAlQEEwEIAD4CGwMFCQeGH4AFCwkIBwIG FQoJCAsCBBYCAwECHgECF4AWIQT6hLaVryv3miBkP/HxBJxynxxlJwUCW1KJJQAKCRDxBJxy nxxlJwjrD/kBgqsW4QpNpTFw7ifRokZV08CCX4huPBJQ91rrv+UEWlEcotFBHVkYyHnpzARl tcZxhJ9CbFxjniH9cOTty5T/O1yolbOHtZSW8Z8aWV6BVEbjMb+BFxSSLm7RnvJdzQbGCZq2 ZZvfVpB6z3EHYph4KDdVKvMFjoLskxmdS1DE0tE3zTxvoQsi24Q+HOS07kUjs6fsu/WICMfz mgO++AWG9Y0CvN0mm4TkujESzyKM9E5irD+leEMIcddl51Aa2c/VMfBXQbRmpHIgUFTmuHQD CnQih+9i3OJAksDg66SP8a7yiXv5mwvyDi1EfTGVKYR2j+pwyjwnC3oIbvDMmB3uTn2JIjnT iZKPVtAcAylXjubFltihQgNyuShdP4W+kBwZizhUFqUVL8Anx+KoytYmJPfMRFLGuK4obXKq a2ZS3k9KB+H+isOx2nFJOsc7V360Zp1DVaNmuiK10TT6QndShSPaqkJqFtCb6r92rZ9sZM/L 3vtCI4Rrl3Pt1MgtENXupS8gZpJnAYS0j5A1PAZ09r6ANoaeMHspF+5J5fOHeEvqphXr36mm a83Vl1t4orPb0+QmmijmlpseDU63M88Aw5p3c4qj7t8Qr2EZ5zrn7/sFn5wOfbs8Nymxafif QCnlV2vg9p0m7vSk/yLJ4PFZvs52FgqAGRCdRn0s2EC99bkCDQRbUocAARAAv8ho/toQ9DG3 j4f9h9n1aRHr2FlviN2Utpy6L8+dfDggO0geilmkGQOolZ2E60gGfye/kUtF9W3NByO4hxDR 9u6qbOXcdqnuA+cc68EfqlWFJrVtYFxt0h4ElWYOYnIezKthriWch/FY70FGrxs3z8UHOHq5 0wBW433eTvZm90WixBiXEt2v1DgW4Vr3ymfO7Aap/IYyPuE4JzgudAuAl0HKPyNEHWHG1dAb jX1RiCw9gknIDWQOF0B4UAaJctWGVcnZ3A2ULwNGMa1P9ZJlBWf1vcj01aiHMU0yQ7JjJiSp vfm9eM0uSLwRdDrJjyl5ZZqVumjdv2SMNQ8GvYRbEMys3GGDSt9zXgfCSUnPnJfYxjzBHRI6 x44Wfsx8S6hWxepOogCJJ/g67Bk9mY8YV4klWIXDJVOL5jnBC09DbsZG81JaE2QxB8Y7W36Z Mroi9XMxg3s805hQAQUvdG/poU8hN8BWdrnTm/+4eQQp7gDY1ePDmGM6bJC+OHOSnFtR/f+7 0zpKJ10cc7cBygGnl1yR3KjhFyAWUFvP4ZGziKCcpMwXZfe9PGuyA/YOubMphxIn3YsK2wrd faKZYX2GMZCZhMMcvx9IpQrxIJgU+VlwXu/O+Lk10VIPcxPJJwmpdI6HzcS8ZgG6IMcC444X XTuLaP8j2mgcMvYak3ScCykAEQEAAYkCPAQYAQgAJhYhBPqEtpWvK/eaIGQ/8fEEnHKfHGUn BQJbUocAAhsMBQkHhh+AAAoJEPEEnHKfHGUnReMP/RA2UhGQj+G4uBshkRLjpRysabdPqgQB dEBk6wYbio88Wg/2/hgY7UzmDDEwX3sZfQDcrI6+vIobI8uqstZID+WgAAa1JLfChMyVQnSy 0zfWMOABXscc5tGuvFRZvJklTissMFjXUwaREEKp4ZikTvJ/62MCjSdtrUhnPLvoTsHTKRKD ichE+b5A54alwsubTijw12O6N22r5IjZiiSZV0u7dsShyKw+7wCSax9fuBoE43NMYf+dnjMK nerAQYUcZWYMnk+EC8RaqYAxv6XZ2tKx1AkGGktwkQIBwrz9IlDSvJ3LWJ2UIIuLRTdngNgg GIL4zzuUa2F56FqskQIuYMaNETk6LYfalBDQ6TVLAcgCPQxp4k4i/PRsZ3lZ2ZhRHRYciOvm kp+I6EfHwllQpYrWs1thluBGqlJSVJgKl0IOFvKLsQ6KKfqzAwh6FxrO5qajp4viNIgtWoFw O5Bp0jgFTbH2OrMWIRfUdUCH1Djbuo65svhNj7FNsQVYzHDI+Nd1I/LOBoPc3UorRMF2M4JV kUR7skOHWUbPTSNUr7qc14NSMY3PKjGeVGAsBVHBPvmRx/Ss2tW/TpJWpxg4pmquFQSXuaYh Yf4FN8Sxy320pcr+FqN8AhZkYJcNY82OTtR5VEKRC/mYcyq61qXIKqngydn79bJjGxHipxyF FmEC Message-ID: Date: Mon, 2 Sep 2019 13:13:41 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:60.0) Gecko/20100101 Thunderbird/60.8.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="TzD8gINHWtuilve0Mgjevv0baOVdQ7Gzs" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --TzD8gINHWtuilve0Mgjevv0baOVdQ7Gzs Content-Type: multipart/mixed; boundary="R32WmIxglRYNrhBdDCfHcUPXTdpO5EKvX"; protected-headers="v1" From: "Jonathan S. Katz" To: Erik Rijkers Cc: Peter Eisentraut , PostgreSQL Advocacy Message-ID: Subject: Re: PostgreSQL 12 Press Release - First Draft References: <0736c146-d9a1-b5e3-4290-866dee8ed2d5@2ndquadrant.com> In-Reply-To: --R32WmIxglRYNrhBdDCfHcUPXTdpO5EKvX Content-Type: multipart/mixed; boundary="------------658E0006391DE6D18D3F1177" Content-Language: en-US This is a multi-part message in MIME format. --------------658E0006391DE6D18D3F1177 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 9/2/19 12:05 PM, Erik Rijkers wrote: > On 2019-09-02 17:36, Jonathan S. Katz wrote: >> On 9/2/19 11:19 AM, Jonathan S. Katz wrote: >>> Please see attached for the latest draft. I tried to move this closer= to >=20 >=20 > 'common-table expression'=C2=A0 should be > 'common table expression' > If you really do prefer the hyphen there then it should also be in the > other usage of 'Common table expressions' in this text, I think. You're correct, there should not be a hyphen there. > 'most-common value'=C2=A0 should be > 'most common value' There seems to be a few ways of doing this; I had gone by what was documented in CREATE STATISTICS[1], so my preference is to leave it as is= =2E > 'that build on the implementation of the SQL standard' Perhaps better: > 'that build on the SQL standard' I modified it with a different take. I think the goal is to capture that PostgreSQL continues to implement newer elements of the SQL standard. "Building on" could sound like that we are adding enhancements on top of the standard (which there are certainly cases where we do :) and I think the end goal is to capture that we are keeping up with the evolution of S= QL. > 'JSON path expressions'=C2=A0 Perhaps better: > 'JSON path expressions' The docs indicate there is a space[2] unless referring to the specific data type, so I would recommend leaving it as is. > And perhaps 'aka' should be fully written out 'also known as'.=C2=A0 Fo= r us > non-native speakers it takes a while before all these abbreviations > become clear. I know it's taken me a few years before I decoded it :) I did a s/aka/also known as/ Thanks! Jonathan [1] https://www.postgresql.org/docs/12/sql-createstatistics.html [2] https://www.postgresql.org/docs/12/functions-json.html#FUNCTIONS-SQLJSON-= PATH --------------658E0006391DE6D18D3F1177 Content-Type: text/markdown; x-mac-type="0"; x-mac-creator="0"; name="release-v5.en.md" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="release-v5.en.md" # PostgreSQL 12 Released! The PostgreSQL Global Development Group today announced the release of Po= stgreSQL 12, the latest version of the world's most advanced open source = database. PostgreSQL 12 enhancements include notable improvements to query performa= nce, particularly over larger data sets, and overall space utilization. T= his release provides application developers with new capabilities such as= SQL/JSON path expression support, optimizations for how common table exp= ression ("WITH") queries are executed, and generated columns. The Postgre= SQL community continues to support the extensibility and robustness of Po= stgreSQL, with further additions to internationalization, authentication,= and providing easier ways to administrate PostgreSQL. This release also = introduces the pluggable table storage interface, which allows developers= to create their own methods for storing data. **HOLD FOR QUOTE** PostgreSQL benefits from over 20 years of open source development and has= become the preferred open source relational database for organizations o= f all sizes. The project continues to receive recognition across the indu= stry, including being featured for the second year in a row as the "DBMS = of the Year" in 2018 by DB-Engines and receiving the "Lifetime Achievemen= t" open source award at OSCON 2019. ## Overall Performance Improvements PostgreSQL 12 provides significant performance and maintenance enhancemen= ts to its indexing system and to partitioning. B-tree Indexes, the standard type of indexing in PostgreSQL, have been op= timized in PostgreSQL 12 to better handle workloads where the indexes are= frequently modified. Using a fair use implementation of the TPC-C benchm= ark, PostgreSQL 12 demonstrated on average a 40% reduction in space utili= zation and an overall gain in query performance. Queries on partitioned tables have also seen demonstrable improvements, p= articularly for tables with thousands of partitions that only need to ret= rieve data from a limited subset. PostgreSQL 12 also improves the perform= ance of adding data to partitioned tables with "INSERT" and "COPY", and i= ncludes the ability to attach a new partition to a table without blocking= queries. There are additional enhancements to indexing in PostgreSQL 12 that affec= t overall performance, including lower overhead in write-ahead log genera= tion for GiST, GIN, and SP-GiST indexes, the ability to create covering i= ndexes (the "INCLUDE" clause) on GiST indexes, the ability to perform K-n= earest neighbor queries with the distance operator ("<->") using SP-GiST = indexes, and CREATE STATISTICS now supporting most-common value (MCV) sta= tistics to help with columns that are nonuniformly distributed. Just-in-time (JIT) compilation using LLVM, introduced in PostgreSQL 11, i= s now enabled by default. JIT compilation can provide performance benefit= s to the execution of expressions in WHERE clauses, target lists, aggrega= tes, and some internal operations, and is available if your PostgreSQL in= stallation is compiled or packaged with LLVM. ## Enhancements to SQL Conformance & Functionality PostgreSQL is known for its conformance to the SQL standard - one reason = why it was renamed from "POSTGRES" to "PostgreSQL" - and PostgreSQL 12 ad= ds several features to continue its implementation of the SQL standard wi= th enhanced functionality. PostgreSQL 12 introduces the ability to run queries over JSON documents u= sing JSON path expressions defined in the SQL/JSON standard. Such queries= may utilize the existing indexing mechanisms for documents stored in the= JSONB format to efficiently retrieve data. Common table expressions, also known as "WITH" queries, can now be automa= tically inlined by PostgreSQL 12, which in turn can help increase the per= formance of many existing queries. In this release, a WITH query can be i= nlined if it is not recursive, does not have any side-effects, and is onl= y referenced once in a later part of a query. PostgreSQL 12 introduces "generated columns." Defined in the SQL standard= , this type of column computes its value from the contents of other colum= ns in the same table. In this version, PostgreSQL supports "stored genera= ted columns," where the computed value is stored on the disk. ## Internationalization PostgreSQL 12 extends its support of ICU collations by allowing users to = define "nondeterministic collations" that can, for example, allow case-in= sensitive or accent-insensitive comparisons. ## Authentication PostgreSQL expands on its robust authentication method support with sever= al enhancements that provide additional security and functionality. This = release introduces both client and server-side encryption for authenticat= ion over GSSAPI interfaces, as well as the ability for PostgreSQL to disc= over LDAP servers if PostgreSQL is compiled with OpenLDAP. Additionally, PostgreSQL 12 now supports a form of multifactor authentica= tion. A PostgreSQL server can now require an authenticating client to pro= vide a valid SSL certificate with their username using the "clientcert=3D= verify-full" option and combine this with the requirement of a separate a= uthentication method (e.g. "scram-sha-256"). ## Administration PostgreSQL 12 introduces the ability to rebuild indexes without blocking = writes to an index via the "REINDEX CONCURRENTLY" command, allowing users= to avoid downtime scenarios for lengthy index rebuilds. Additionally, PostgreSQL 12 can now enable or disable page checksums in a= n offline cluster using the "pg_checksums" command. Previously page check= sums, a feature to help verify the integrity of data stored to disk, coul= d only be enabled at the time a PostgreSQL cluster was initialized with "= initdb." PostgreSQL 12 also introduces progress reporting statistics for the "CREA= TE INDEX", "REINDEX", "CLUSTER", and "VACUUM FULL", operations, and to th= e "pg_checksums" command via the "--progress" flag. For a full list of features included in this release, please read the=C2=A0= release notes, which can be found at: https://www.postgresql.org/docs/12/= static/release-12.html ## About PostgreSQL PostgreSQL is the world's most advanced open source database, with a glob= al community of thousands of users, contributors, companies and organizat= ions. The PostgreSQL Project builds on over 30 years of engineering, star= ting at the University of California, Berkeley, and has continued with an= unmatched pace of development. PostgreSQL's mature feature set not only = matches top proprietary database systems, but exceeds them in advanced da= tabase features, extensibility, security, and stability. Learn more about PostgreSQL and participate in our community at PostgreSQ= L.org. --------------658E0006391DE6D18D3F1177-- --R32WmIxglRYNrhBdDCfHcUPXTdpO5EKvX-- --TzD8gINHWtuilve0Mgjevv0baOVdQ7Gzs Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAl1tTcUACgkQ8QSccp8c ZSd5nhAArnJ5yFjpJko3e1+zpmbOD3UHj75KvAIQ6IinZNvqel2IkN923JlX1RbH TLFr16CJKRnJC6Fkzokt6oVrM9FuPFVKLo0HhOYt7q1gc+E/yhdhDpvaP92LXXmY 6jPwsT7GCRsSYa7JpZ57fK2FKB5VOb9Nf2ZZ64GGQrlEGtQ5x7Eh0m9D3Qr/Iqdi CN3KEvqFr8MYRmy62u8uelQiexG9yPawe8RD9Z2nYAdfdgsJPJrjBzvfmy1rdEAa nGADBjFCdWQGzMv4tP+QXVp1D6lHi1BzXHhASRd3GtEYZ1U+bH6F44/mELW5u7jg SU0MWXM1al6fxEF0wfCJcT2gD9rai5e7m56vGgnCALuHQ+5l2LU7PdXEu5MbMGmN 75mcRenbidR7UFv3eHzMcOQs16R+qhktD2cDvbNlz7cadxBQVo8aIz6TlxoBmy8k puH1epMnpOp7LgS+v2GZgiLOUk0jl3ifHGq9fdI16rRzPXfU1QJTuOlJc/HzYmGf CbjbqVQK29H6Yr98duWQbBguZyFZYtUZCloAKFrDZbwZLcAbaNP6+8qrkdvfLeEW 1AHywkGZy45F1Z5hoyBrMfQHP9nXn37bbtlTGv0vs1npF7JDI5eudoKtwXOT3t0G Z9x7SIKK1BnoAxV/3aadBwM/N6eDj60lbZZAc9MUWzHJ0B/GOiw= =5PSp -----END PGP SIGNATURE----- --TzD8gINHWtuilve0Mgjevv0baOVdQ7Gzs--