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 1i4o7s-0007rw-JD for pgsql-advocacy@arkaria.postgresql.org; Mon, 02 Sep 2019 15:20:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1i4o7q-0004HF-G1 for pgsql-advocacy@arkaria.postgresql.org; Mon, 02 Sep 2019 15:20:14 +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 1i4o7q-0004H7-0M for pgsql-advocacy@lists.postgresql.org; Mon, 02 Sep 2019 15:20:14 +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 1i4o7i-0000TR-1U for pgsql-advocacy@lists.postgresql.org; Mon, 02 Sep 2019 15:20:13 +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:To:Subject:Sender:Reply-To:Cc: Content-Transfer-Encoding:Content-ID:Content-Description; bh=JKj44q0HDchsEig5MnMJMcvyp2D0x2jadcqTvVv82UI=; b=MmXczVdEuk2aOB/K3/c3h+iMTM LpGrYOprUKxVxGNbhl4b0Fc+I/j5Q/I6JV7NNhcsdKZD4kpVLyf91ARpRabPXEcRnOBVXRlrMlWza 6TPS6+cEnf5VBRFc+SgjudU6QI3MfqZqbg9EVOFrL3tvGJtqFovLevDBFlHnRSTuAf15vTB1RfRIE JGysFiES5FYnUgRBPKYBJySYn0XkXmvOtV9vjphPF1NJ5KxAUqpAYMvVqtT086NOlrp6pYG1HooQ6 ouoDnH0WA3KYiEUEpI9ts+j5stypS9fWCNonbXzN6qxdenBMFvK466LNpHf6vOyCVRR7Wpbu+UCdn Q8zHUUmw==; 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 1i4o7e-0000NR-B5; Mon, 02 Sep 2019 15:20:05 +0000 Subject: Re: PostgreSQL 12 Press Release - First Draft To: 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 11:19:58 -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: <0736c146-d9a1-b5e3-4290-866dee8ed2d5@2ndquadrant.com> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="7oahtL8DU9CbegkUPxvqumGXEtLJOZa3d" 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) --7oahtL8DU9CbegkUPxvqumGXEtLJOZa3d Content-Type: multipart/mixed; boundary="qw7E7RL0U97S7rGvW5VUEURTU5o4xZzIU"; protected-headers="v1" From: "Jonathan S. Katz" To: 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: <0736c146-d9a1-b5e3-4290-866dee8ed2d5@2ndquadrant.com> --qw7E7RL0U97S7rGvW5VUEURTU5o4xZzIU Content-Type: multipart/mixed; boundary="------------B75D2DDFC654F5E3AE6574D0" Content-Language: en-US This is a multi-part message in MIME format. --------------B75D2DDFC654F5E3AE6574D0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi Everyone, On 8/25/19 5:01 AM, Peter Eisentraut wrote: > On 2019-08-21 22:43, Jonathan S. Katz wrote: >> - Administrative (REINDEX CONCURRENTLY, pg_checksums) >=20 > Enhancements to progress tracking of various utility commands might fit= > in under this heading. >=20 > Other than that, I don't see anything major to be added. >=20 >=20 > The file you attached contains a confusing selection of non-ASCII > characters such as curly quotes and non-breaking spaces. Nothing wrong= > with using those, of course, but it's not done consistently and looks > gratuitous. You should look into cleaning that up so that this doesn't= > get messed up further by downstream processors of the press release. Thank you all for your feedback, it was incredibly helpful! I waited a few days before incorporating changes to try to limit the back-and-forth.= Please see attached for the latest draft. I tried to move this closer to the final markdown version (e.g. to Peter's point above) though there is some additional formatting I will provide before the final one. Again, please keep your feedback coming through September 6, 2019 AOE[1]. I will let you know if there is an extension, of course :) Thanks! Jonathan [1] https://en.wikipedia.org/wiki/Anywhere_on_Earth --------------B75D2DDFC654F5E3AE6574D0 Content-Type: text/markdown; x-mac-type="0"; x-mac-creator="0"; name="release-v3.en.md" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="release-v3.en.md" # PostgreSQL 12 Released! The PostgreSQL Global Development Group today announced the release of Po= stgreSQL 12, the latest version of the world=E2=80=99s 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 =E2=80=93 one= reason why it was renamed from "POSTGRES" to "PostgreSQL" =E2=80=93 and = PostgreSQL 12 adds several features that build on the implementation of t= he SQL standard and offer 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, aka "WITH" queries, can now be automatically in= lined by PostgreSQL 12, which in turn can help increase the performance o= f many existing queries. In this release, a WITH query can be inlined if = it is not recursive, does not have any side-effects, and is only referenc= ed 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=C2=A0is the world's most advanced open source database, with a= global community of thousands of users, contributors, companies and orga= nizations. The PostgreSQL Project builds on over 30 years of engineering,= starting at the University of California, Berkeley, and has continued wi= th an unmatched pace of development. PostgreSQL's mature feature set not = only matches top proprietary database systems, but exceeds them in advanc= ed database features, extensibility, security, and stability. Learn more about PostgreSQL and participate in our community at=C2=A0Post= greSQL.org. --------------B75D2DDFC654F5E3AE6574D0-- --qw7E7RL0U97S7rGvW5VUEURTU5o4xZzIU-- --7oahtL8DU9CbegkUPxvqumGXEtLJOZa3d Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAl1tMx4ACgkQ8QSccp8c ZSfGjA//ZVAHy1X1KRF01Gxo5uAhQQHI0LiudoABRBz+ANkay7ayXvjQLYGhFbeh nZuCGI0dV/F3QvgOn7c+Rs9SbRuHNnFbnbkciB/bmMAHVkicGtGLMqLQi14wqoJu hOuMBiokxVmz3/61WMVsq1riLw1KDFDRCBlezEoEqxkukDSTHr72p8j+FS+UKiR+ L3K1qvOkdVA0vq6dCUR6QDasMw1WB5zcRHRaKLOuhlSwhkfqmjuFFEU7BI7wAgUU THw0BWCnWo7Q8kWZa9kaO34aVifCnBMH9wv1mmqf9VWSOhDj/YIMalD4YOO6u8QO 2lAZh3vF+uTNuUBfC47dFeLoMr5wy28t0oor9ro16BkNtBYQeY3SHkX+GO4AkfCq f3xSx03Hdvx+Z5IIVE2cd5it7vdvU5KRy9+piZwEgUY2LJXEvYqsOcRo3MzQjWYY 9HLblSfMLA4ncZRop6FskU4pahO0skT973RcTAbyrA1Sov8XnvFEI+Q/3btpxm+w E1PIgCyNAruoHF36xCRuJc2Ea/YZOAhSHcvLYsyVI4dshfGjhi27GctywoTlxgct ozNWjGHT4iC70qrrFMqPO5MfR6zgZ4j6bMtxdn+TQszG9quUsE5k5v+l1RaPAkwS UOJ/KN7lVYXenF7NC7LUUJ5nrYitnyxQhWr/HxWY499ApSeHWAM= =bInb -----END PGP SIGNATURE----- --7oahtL8DU9CbegkUPxvqumGXEtLJOZa3d--