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 1i0Xt2-0000mQ-0D for pgsql-advocacy@arkaria.postgresql.org; Wed, 21 Aug 2019 21:11:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1i0Xsz-0001oH-Qe for pgsql-advocacy@arkaria.postgresql.org; Wed, 21 Aug 2019 21:11:17 +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 1i0Xsz-0001oA-Hz for pgsql-advocacy@lists.postgresql.org; Wed, 21 Aug 2019 21:11:17 +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 1i0Xsv-0007Bw-Fm for pgsql-advocacy@lists.postgresql.org; Wed, 21 Aug 2019 21:11:17 +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=0GuLxakU/DC/AiDYqcnd1kGErb5x5fy+tk5O2a4bE4U=; b=fqBsjx9Mri6Omk7LVSnaiQ8A60 Ma9t5GkWax7hhPkRjIJrXDWI2KWZmLFBY87S7bVZkUx0PmQUM69H2drCiWWGT0/GnahwKse1xMLBt 0scI0uim5t0F0G3WC9OrOuP1ijMNm0Ehao3Xr+ElXWRnyFm1ob3XmzkuitXnNkGhC3trcaNcNAYFb 6YF2pBGJegHw6ymJzmHDgTggtYqi5Aqy9lkuyZJ0r3YBNI6Z44mWTS3J5YSmNcOzUoaYFBxUGfeVf YprYmbQrKTbBhYSBTFlMVUHVZQe7uV99QladFxA5YW0fdvW/g9Ku4rwC0Lo1ns6nZ1vlT3UqE6nUc +gZsf/4A==; 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 1i0Xss-0005P4-BK; Wed, 21 Aug 2019 21:11:13 +0000 Subject: Re: PostgreSQL 12 Press Release - First Draft To: Erik Rijkers Cc: PostgreSQL Advocacy References: 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: <7640cf7b-f26a-70ca-bf7b-ef71ddd866bc@postgresql.org> Date: Wed, 21 Aug 2019 17:11:07 -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="1ByK02PDzm1nondLrKtyiurFXREo8eYVQ" 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) --1ByK02PDzm1nondLrKtyiurFXREo8eYVQ Content-Type: multipart/mixed; boundary="LGPx9x7zrxWm9JIWsbtFbJy3SRZQH3TOz"; protected-headers="v1" From: "Jonathan S. Katz" To: Erik Rijkers Cc: PostgreSQL Advocacy Message-ID: <7640cf7b-f26a-70ca-bf7b-ef71ddd866bc@postgresql.org> Subject: Re: PostgreSQL 12 Press Release - First Draft References: In-Reply-To: --LGPx9x7zrxWm9JIWsbtFbJy3SRZQH3TOz Content-Type: multipart/mixed; boundary="------------925B983A0EA8A40B7E1D417D" Content-Language: en-US This is a multi-part message in MIME format. --------------925B983A0EA8A40B7E1D417D Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 8/21/19 5:02 PM, Erik Rijkers wrote: > On 2019-08-21 22:43, Jonathan S. Katz wrote: >> Hi, >> >> Attached is a first draft of the press release for PostgreSQL 12. >=20 > A few typos: >=20 > 'PostgreSQL 12 also improvements the performance of'=C2=A0 should be > 'PostgreSQL 12 also improves the performance when' >=20 > 'with blocking any queries'=C2=A0 should be (I think) > 'without blocking any queries' >=20 > 'write-head-log'=C2=A0 should be > 'write-ahead-log' >=20 > 'that can be computed its value from other columns' > 'that can compute its value from other columns' >=20 > and something is not quite right about the sentence containing: > 'LDAP servers using if it' > but I can't figure out what it should be. Thanks! I incorporated most of your suggestions in the updated copy. Jonathan --------------925B983A0EA8A40B7E1D417D Content-Type: text/markdown; x-mac-type="0"; x-mac-creator="0"; name="release.en.md" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="release.en.md" # PostgreSQL 12 Released! The PostgreSQL Global Development Group today announced the release of PostgreSQL 12, the latest version of the world=E2=80=99s most advanced op= en source database. PostgreSQL 12 enhancements include notable improvements to query performance, particularly over larger data sets, and overall spa= ce utilization. This release provides application developers with new capabi= lities such as SQL/JSON path expression support, optimizations for how common-ta= ble expression ("WITH") queries are executed, and generated columns. The Post= greSQL community continues to support the extensibility and robustness of Postgr= eSQL, with further additions to internationalization, authentication, and provi= ding easier ways to administrate PostgreSQL. This release also introduces the pluggable table storage interface, which allows developers to create thei= r 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 of all si= zes. The project continues to receive recognition across the industry, includi= ng being featured for the second year in a row as the "DBMS of the Year" in = 2018 by DB-Engines and receiving the "Lifetime Achievement" 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 frequen= tly modified. Using a fair use implementation of the TPC-C benchmark, Postgre= SQL 12 demonstrated on average a 40% reduction in space utilization and an overa= ll gain in query performance. Queries on partitioned tables have also seen demonstrable improvements, particularly for tables with thousands of partitions that only need to re= trieve data from a select few. PostgreSQL 12 also improves the performance of adding data to partitioned tables with "INSERT" and "COPY", and a new par= tition can now be attached 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 generati= on for GiST, GIN, and SP-GiST indexes, the ability to create covering indexes (t= he "INCLUDE" clause) on GiST indexes, the ability to perform K-nearest neighbor queries with the distance operator ("<->") using SP-GiST indexes= , and CREATE STATISTICS now supporting most-common value (MCV) statistics to he= lp with columns that are nonuniformly distributed. ## 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 a= dds several features that build on the implementation of the SQL standard and offer e= nhanced functionality. PostgreSQL 12 introduces the ability to run queries over JSON documents u= sing JSON path expressions defined in the SQL/JSON standard. Additionally, cer= tain JSON path expressions can utilize the existing indexing mechanisms for do= cuments 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 of many= existing queries. In this release, a WITH query can be inlined if it is n= ot recursive, does not have any side-effects, and is only referenced once in= a later part of a query. PostgreSQL 12 also introduces generated columns, which is a type of colum= n that can be computed its value from other columns in the same table. Currently= , PostgreSQL only supports "stored generated columns," where the computed v= alue 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-insensiti= ve or accent-insensitive comparisons. ## Authentication PostgreSQL expands on its robust authentication method support with sever= al enhancements that provide additional security and functionality in PostgreSQL 12. This release introduces both client and server-side encryp= tion for authentication over GSSAPI interfaces, as well as the ability for Pos= tgreSQL to discover 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 authentication client to provide a v= alid SSL certificate with their username using the "clientcert=3Dverify-full" = option and combine this with the requirement of a separate authentication 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 avo= id 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 checksu= ms, a feature to help verify the integrity of data stored to disk, could only b= e enabled at the time a PostgreSQL cluster was initialized with "initdb." 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/r= elease-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 organization= s. The PostgreSQL Project builds on over 30 years of engineering, starting at th= e University of California, Berkeley, and has continued with an unmatched p= ace of development. PostgreSQL's mature feature set not only matches top proprie= tary database systems, but exceeds them in advanced database features, extensi= bility, security, and stability. Learn more about PostgreSQL and participate in our community at=C2=A0Post= greSQL.org. --------------925B983A0EA8A40B7E1D417D-- --LGPx9x7zrxWm9JIWsbtFbJy3SRZQH3TOz-- --1ByK02PDzm1nondLrKtyiurFXREo8eYVQ Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAl1ds2sACgkQ8QSccp8c ZScg7Q/9HhAT87H/wQLm2tfLPTaFgIBrKWGvrzWabdFUiOlelKtsJMPNmtl4BiEo sE13IPIRUH9Si43ozpQVuCIrUN6MV23g3wTch7JRihCG5p20Qn2jjL10qMwBuLDU 0zMOYPvUT+39MyEauHv/DBAMFCUEof0MoLyOcmrT3wOKWyuy/jEudd8MQSgJi5vs wS5bTztqQnATMOzzWx8cP6nyrjOgovFtJQnBHkUQZUkAAUmlAdoJqDQCnquEJLD8 WdJZqs3+YYNw4wH3eyZC7zoCdHB+QpAX0kly26Vkt50jrXmAIGRfXtVi+VJy6DeY 7sMsY9lOy8TYh+fgW2U0EAANTiNEXES288TfO5q8ypvRXNPz6fkgaSq1cdTka2oD ynNWRkbW145A/W4yPhKrtJX4m4NQme0b+vJCysGAD1fLUJl9UaRHejzEENYa1Uur N5ED5K8sbh18tMzQ86gsRnXfEtSk66ftb+Ohy9r1O0ORxpLWDTHzz6PiV+gtnBj9 Ju/+BkSTveeKXwC9e4rpRfl56Kf359uCrw6t4JaLz9nSaM/yYKf1sisb22dCAHmZ eBHzmjsgjPx1QnhHHRUBYkUj2e1EltUNGW7NC78TLaUC4L2fUvPaJa7lAjPdYOwH +0tiBlen4xbNeLCjQFxFmTlt3cMN4KGTU5SWf01HsBTfjToqaCw= =HW6k -----END PGP SIGNATURE----- --1ByK02PDzm1nondLrKtyiurFXREo8eYVQ--