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 1hQjGX-00026q-6w for pgsql-advocacy@arkaria.postgresql.org; Wed, 15 May 2019 02:03:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hQjGV-0000Ee-1Q for pgsql-advocacy@arkaria.postgresql.org; Wed, 15 May 2019 02:03:31 +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 1hQjGU-0000EW-GH for pgsql-advocacy@lists.postgresql.org; Wed, 15 May 2019 02:03:30 +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 1hQjGO-0006Rn-8G for pgsql-advocacy@lists.postgresql.org; Wed, 15 May 2019 02:03:30 +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=Mtmj5S3IU9L8ErgwEXdeRhjO4lWH7QPMfB3g0M2Iecg=; b=qPhLyR+lDxccWnw0kS9/AfM5j3 T4Beiuh4ZJfitNaTZ+6SWuqmO71ZzouTKqqDJd7U4qyk+5CaN3YbCJ9BVI46RSsyn/Z5OB+pZ37Zl yCjFFCvx+wK5w0QaU6YMLLaQSneknm61mLy+U4iBiO3qljnpGCQPeNBeeLy9D8h2I1k/sN6A2iT6J je/Q6w69HsaFlPxFLagA0qydlvc5vQ6gUZdheYYWBZL99YxM7Vyax7kwV5RAjEiec3H0xFmDCevOf Wefor21t6h2UofnMJ5V9uDlxyelf543BEYL27MCPnto86BWxYEj11HXJB6lv/HYHbkgZ3rAJrZK/G 9xN7x13g==; Received: from pool-96-250-83-19.nycmny.fios.verizon.net ([96.250.83.19] 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 1hQjGK-0001Vx-AK for pgsql-advocacy@lists.postgresql.org; Wed, 15 May 2019 02:03:22 +0000 Subject: Re: PostgreSQL 12: Feature Highlights From: "Jonathan S. Katz" To: pgsql-advocacy@lists.postgresql.org References: <830415f7-78ec-ef7b-0f73-0e810ef87f91@postgresql.org> 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: Tue, 14 May 2019 22:03:16 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:60.0) Gecko/20100101 Thunderbird/60.6.1 MIME-Version: 1.0 In-Reply-To: <830415f7-78ec-ef7b-0f73-0e810ef87f91@postgresql.org> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="mYc84P2Mb5IpU2TrwV01W5tG560dAfDbD" 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) --mYc84P2Mb5IpU2TrwV01W5tG560dAfDbD Content-Type: multipart/mixed; boundary="yrcUEvAZ4gqKg8kDFy8XtDg1LEXYyH4kq"; protected-headers="v1" From: "Jonathan S. Katz" To: pgsql-advocacy@lists.postgresql.org Message-ID: Subject: Re: PostgreSQL 12: Feature Highlights References: <830415f7-78ec-ef7b-0f73-0e810ef87f91@postgresql.org> In-Reply-To: <830415f7-78ec-ef7b-0f73-0e810ef87f91@postgresql.org> --yrcUEvAZ4gqKg8kDFy8XtDg1LEXYyH4kq Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable Hi, On 5/12/19 11:28 AM, Jonathan S. Katz wrote: > Hi, >=20 > Now that a draft of the release notes are available[1] this seems like = a > good time to begin determining what features we want to highlight prior= > to the Beta 1 announcement. Thank you everyone for your feedback. Below is v2 of the list for the Beta 1 announcement. A few things to note: - Based on feedback I made several INSERT/UPDATE/DELETE operations on the list ;) - I know it's listing out a lot of features, but this is the Beta 1 release, which, among several goals, is to make people aware of as many impactful features as possible for purposes of awareness and getting people to help test. - The press release will be better worded - this is just a list :) Without further ado: # Feature Highlights 1. Indexing - Improvements overall performance to standard (B-tree) indexes with writes as well as with bloat - REINDEX CONCURRENTLY - GiST indexes now support covering indexes (INCLUDE clause) - SP-GiST indexes now support K-NN queries - WAL overhead reduced on GiST, GIN, & SP-GiST index creation 2. Partitioning Improvements - Improved partition pruning, which improves performance on queries over tables with thousands of partitions that only need to use a few partition= s - Improvements to COPY performance and ATTACH PARTITION - Allow foreign keys to reference partitioned tables 3. WITH queries (CTEs) can now be inlined, subject to certain restriction= s 4. Support for JSON path queries per the SQL/JSON specification in the SQL:2016 standard. A subset of these expressions can be accelerated with on-disk indexes. 5. Support for case-insensitive and accent-insensitive collations 6. CREATE STATISTICS now supports most-common value statistics, which leads to improved query plans for distributions that are non-uniform 7. Introduction of generated columns that compute and store an expression as a value on the table 8. Introduction of CREATE ACCESS METHOD that permits the addition of new table storage types 9. Enable / disable page checksums for an offline cluster 10. Authentication - GSSAPI client/server encryption support - LDAP server discovery # Changes That Can Affect Existing Operating Environments 1. recovery.conf merged into postgresql.conf; recovery.signal/standby.signal being used for switching into non-primary mode 2. JIT enabled by default Thanks, Jonathan --yrcUEvAZ4gqKg8kDFy8XtDg1LEXYyH4kq-- --mYc84P2Mb5IpU2TrwV01W5tG560dAfDbD Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAlzbc2QACgkQ8QSccp8c ZSfT4w/9EduSxShzibMF1J1/GqT/g2ABCXTR7Vd6MV6+ixI2RLkKR5rnWd1+yPnb qwaFkNBM5peUuqZXTPIJ0Zhtw1mFQ/VIjl+zewxbCXYv/gyjVMggQqZR9+Oe+QZh bLyF7c7G5uGU3lGbPuZABn2zFppOIFHU9Mw/+bhsXCXdnTw66SUUCy/2qXfIUfA4 G9eg3rHTw5hVGQgYHS+IymY2wb7aezrKncTLS06Cnxc/IytZdt02ErmCnuV9BeMH zO5GGxGT+Zna0yjvSpFrWhDJQEBBshkKq2fdp8MGWni8yctwr0xa/bcl+YBjnflZ bp0/EF+bcPmla+phu5A5ltBfJvzbkolR9AQudrmDztasMg6RNyC3mTUVhQE+qZ0b Hwi5ES3s7Hky2WU28z9HI3D39p+awsDphH+c4CVVCi8idYHddtXDv3WSzV3FPlhA 6uEJFzJ5wqpVQ9GSv5PQS49UoCkCrfZSXPrGSflX5zIsftFKFtlYjuEVv/wGAupC CVIpN2z+OqXQjNKIm3jy+ADba6KEXbTWwMXhTEFjI+GsQiCWZJabzkkCgw9/Ij0h gyhJL+UbbeF9JGRw0I/71FVnrWo76G4/+K77UroLuFeZOcW4ekAQb/2isqM+yyg5 HCMc0MBA3+yWYGTihxN4zicq3kXKsVS5Lkhil8+PMuM5D7XMoag= =8Uld -----END PGP SIGNATURE----- --mYc84P2Mb5IpU2TrwV01W5tG560dAfDbD--