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 1i4oNh-000068-6m for pgsql-advocacy@arkaria.postgresql.org; Mon, 02 Sep 2019 15:36:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1i4oNf-0003eL-Vu for pgsql-advocacy@arkaria.postgresql.org; Mon, 02 Sep 2019 15:36:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i4oNf-0003XI-Gv for pgsql-advocacy@lists.postgresql.org; Mon, 02 Sep 2019 15:36:35 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1i4oNc-0003Hd-Dn for pgsql-advocacy@lists.postgresql.org; Mon, 02 Sep 2019 15:36:34 +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:References:To:From:Subject:Sender:Reply-To:Cc: Content-Transfer-Encoding:Content-ID:Content-Description; bh=wLkK/HZJrYxECWyKSfw7bc17pDL3bZT8qAwbGce8SSM=; b=ZlEx4Ls2akD/SWxKy0T/Niak9G ZTI+3V6QBl7OgeFuz+lGb5rZq6AwhvLUI0iTligOC6VoA+Tl0LKgBqLXRNCUwnYQtRgg7zzjEmb76 layiPeheBvkFfTMJOZPXhcmhX2Kpv/wXtYwocZll4XekYVEALTImX3unyR73K1XCmRsChOCN4EgtA rJsHYx1yUeJhhU3jrflGbdUZpVwAnTokVqGwc8AKhp/fcHbKrv10WJVxSNuaCkl+y1WMIu8gDXg30 76i0ZQcxFxcWenAtNcrp+GtRiYGfr5jdlK5Apk/GQMOQmeRvqvxk6Uu431TB1avluQ1SldzEihuAH c9hShfWw==; 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 1i4oNY-0000nA-1f; Mon, 02 Sep 2019 15:36:30 +0000 Subject: Re: PostgreSQL 12 Press Release - First Draft From: "Jonathan S. Katz" To: Peter Eisentraut , PostgreSQL Advocacy References: <0736c146-d9a1-b5e3-4290-866dee8ed2d5@2ndquadrant.com> 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:36:24 -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="g8OvEP5FSzFviuaMqP0xEZ2mq8fyBxgaK" 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) --g8OvEP5FSzFviuaMqP0xEZ2mq8fyBxgaK Content-Type: multipart/mixed; boundary="s52a9oAmHJtQvX7N0b8gqaf5xtm1uAUeG"; 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: --s52a9oAmHJtQvX7N0b8gqaf5xtm1uAUeG Content-Type: multipart/mixed; boundary="------------8FD45DA88B61B8BCD86A9504" Content-Language: en-US This is a multi-part message in MIME format. --------------8FD45DA88B61B8BCD86A9504 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 9/2/19 11:19 AM, Jonathan S. Katz wrote: > Hi Everyone, >=20 > On 8/25/19 5:01 AM, Peter Eisentraut wrote: >> >> The file you attached contains a confusing selection of non-ASCII >> characters such as curly quotes and non-breaking spaces. Nothing wron= g >> 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. > > Please see attached for the latest draft. I tried to move this closer t= o > the final markdown version (e.g. to Peter's point above) though there i= s > some additional formatting I will provide before the final one. And no sooner do I say that do I find additional broken formatting. Please see attached with updates. Jonathan --------------8FD45DA88B61B8BCD86A9504 Content-Type: text/markdown; x-mac-type="0"; x-mac-creator="0"; name="release-v4.en.md" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="release-v4.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 that build on the implementation of the 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. --------------8FD45DA88B61B8BCD86A9504-- --s52a9oAmHJtQvX7N0b8gqaf5xtm1uAUeG-- --g8OvEP5FSzFviuaMqP0xEZ2mq8fyBxgaK Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAl1tNvgACgkQ8QSccp8c ZScohw/+KfBkV/GgjawwFcRS68Zlm5TQJPp2vnqH+cw0QnECI94L55CGZqKpf2xW sjjN9MrW+IC6C4B1VGlTgjK3gBhfCiCGiwM1dD4hhOyddroMad+U8sq89VsXaYE4 /dDh+0RIEtlsJgyyD80dRUWnXVP2DnbKn7ya9f9HlmMyb5J3ahTwow4xrRscEd5s H9+IJOUlat9EyixZGACKR/onzwmUT2r78Yb33PR6KjGUQ82Xmv5WHCcb+23O0Icl K+yNARfy/FnaToBgUeBgob5QjQHZrJxB9srBS8H6pv8gtIzjI+uYLY/GzlVfxHA7 q1YXDBt0PzYc/AMxESTEmkZfqc8rAOvvfb5xoHJFTomEKbQw8HUYp5vC1U9y43sp lDk511EhhkIa9hA1YDtILkmYn4oKOYdSJxHxXzW2Zg6L4Z8OFJH0lmDMbim+fI9v SgXVsd5mf9KmI5PzprqJZrhNixWetKKGxk8MB54lsDn/gwykFi+4XqNIsd3XOIUI uDTkQDASDTikbI08FfQ9ccRHKJ8rE+8p0pqWxtsZPvL19GWlfxdP5Oto6BJy9Rf2 adNHCPDlwgLQT9hzy2noF8qcDTKV8VTkvh9HSaj11tO5rCQFeT2jOKSuKo/H737y yNoeGdqjY4xLM4iFYeeTmlrD1Ln8OG72VPWl39CNxyox+1cfoCg= =55sJ -----END PGP SIGNATURE----- --g8OvEP5FSzFviuaMqP0xEZ2mq8fyBxgaK--