Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kICS4-0002a0-Ga for pgsql-hackers@arkaria.postgresql.org; Tue, 15 Sep 2020 15:01:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kICS3-000129-5i for pgsql-hackers@arkaria.postgresql.org; Tue, 15 Sep 2020 15:00:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kICS2-000122-Sg for pgsql-hackers@lists.postgresql.org; Tue, 15 Sep 2020 15:00:58 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kICS0-0002Kk-84 for pgsql-hackers@postgresql.org; Tue, 15 Sep 2020 15:00:58 +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:Subject:References:Cc:To:From:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=aMC+xlsLx6wJKjJgGljjsBu2tKe4C/E56CFGzdimKuE=; b=q1E2lOI7jw8xySdeuMx8CdmO57 6xoBkG+ZSfuNhbzVyrdZxTNb3jZsBPeAJUgbDaRqVMaFshpXg3CSWOUXmI8yiIV/roM5zvla/gIkv TPfXlpTelAs1A2INVvA7YJHd9WHP9R+cDDEfKsqVzx6+aEuhTSkuSbQ3rBWIlprvNvMDYDj4q+MLG EHukS3lAuh+ex4nITVDOV4rlTQspWr3sis9zy6kJEwtvTa/miYtibbVYnGoUGNQ1+Y/kj4Fzcfdb5 FH0sztzev+hFYWC4W8hxjIeXihY/H4T7jNR+Z+t43U1yBJgjlgaV+5Z3tmqcGgQlBO/4pqU7zxALD iFZBdb0A==; Received: from pool-173-56-10-231.nycmny.fios.verizon.net ([173.56.10.231] helo=Ph33rHippo.home) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kICRx-0007a0-Ef; Tue, 15 Sep 2020 15:00:56 +0000 From: "Jonathan S. Katz" To: Masahiko Sawada , Peter Eisentraut Cc: Bruce Momjian , PostgreSQL-development References: <20200505031600.GB21752@momjian.us> <448a382b-ae07-3126-5a08-aacda9aa28ea@postgresql.org> <63d3f3aa-e42d-dd3d-643c-2e91a13a0762@postgresql.org> 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 Subject: Re: PG 13 release notes, first draft Message-ID: Date: Tue, 15 Sep 2020 11:00:50 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:68.0) Gecko/20100101 Thunderbird/68.12.0 MIME-Version: 1.0 In-Reply-To: <63d3f3aa-e42d-dd3d-643c-2e91a13a0762@postgresql.org> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="AU4ent38VKqGi4TFQST0zHS8RqAvQfzGT" 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) --AU4ent38VKqGi4TFQST0zHS8RqAvQfzGT Content-Type: multipart/mixed; boundary="M1nFr7bQRma1hvNFn0Gji8gH72qxPceCk"; protected-headers="v1" From: "Jonathan S. Katz" To: Masahiko Sawada , Peter Eisentraut Cc: Bruce Momjian , PostgreSQL-development Message-ID: Subject: Re: PG 13 release notes, first draft References: <20200505031600.GB21752@momjian.us> <448a382b-ae07-3126-5a08-aacda9aa28ea@postgresql.org> <63d3f3aa-e42d-dd3d-643c-2e91a13a0762@postgresql.org> In-Reply-To: <63d3f3aa-e42d-dd3d-643c-2e91a13a0762@postgresql.org> --M1nFr7bQRma1hvNFn0Gji8gH72qxPceCk Content-Type: multipart/mixed; boundary="------------3981EECDB536F5A9B923F485" Content-Language: en-US This is a multi-part message in MIME format. --------------3981EECDB536F5A9B923F485 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 9/15/20 9:49 AM, Jonathan S. Katz wrote: > On 9/15/20 5:22 AM, Masahiko Sawada wrote: >> On Tue, 15 Sep 2020 at 13:56, Peter Eisentraut >> wrote: >>> >>> On 2020-09-09 22:57, Jonathan S. Katz wrote: >>>> + >>>> + >>>> + Parallelized vacuuming of B-tree indexes >>>> + >>>> + >>> >>> I don't think B-tree indexes are relevant here. AFAICT, this feature= >>> applies to all indexes. >>> >> >> Yes, parallel vacuum applies to all types of indexes provided by >> PostgreSQL binary, and other types of indexes also can use it. >=20 > I'm not sure where I got B-tree from. I've attached a correction. On a different note, I became aware of this[1] and noticed that dropping "CREATE EXTENSION ... FROM" was not listed in the incompatibilities section, so proposing the attached. I have no strong opinions on the final wording, mainly wanted to get it listed. Thanks, Jonathan [1] https://trac.osgeo.org/postgis/ticket/4753 --------------3981EECDB536F5A9B923F485 Content-Type: text/plain; charset=UTF-8; x-mac-type="0"; x-mac-creator="0"; name="create-extension-from.patch" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="create-extension-from.patch" ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWxlYXNlLTEzLnNnbWwgYi9kb2Mvc3JjL3Nn bWwvcmVsZWFzZS0xMy5zZ21sCmluZGV4IDBjYTk3MGU0NTIuLjhmYmFmZjQ2MjMgMTAwNjQ0 Ci0tLSBhL2RvYy9zcmMvc2dtbC9yZWxlYXNlLTEzLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21s L3JlbGVhc2UtMTMuc2dtbApAQCAtMzI0LDYgKzMyNCwxOSBAQCBBdXRob3I6IFBldGVyIEdl b2doZWdhbiA8cGdAYm93dC5pZT4KICAgICAgPC9wYXJhPgogICAgIDwvbGlzdGl0ZW0+CiAK KyAgICA8bGlzdGl0ZW0+Cis8IS0tCitBdXRob3I6IFRvbSBMYW5lIDx0Z2xAc3NzLnBnaC5w YS51cz4KKzIwMjAtMDItMTkgWzcwYTc3MzIwMF0gUmVtb3ZlIHN1cHBvcnQgZm9yIHVwZ3Jh ZGluZyBleHRlbnNpb25zIGZyb20gInVucGFja2FnZWQKKy0tPgorCisgICAgIDxwYXJhPgor ICAgICAgUmVtb3ZlIHN1cHBvcnQgZm9yIDxsaW5rIGxpbmtlbmQ9InNxbC1jcmVhdGVleHRl bnNpb24iPjxjb21tYW5kPkNSRUFURQorICAgICAgRVhURU5TSU9OIC4uLiBGUk9NPC9jb21t YW5kPjwvbGluaz4KKyAgICAgIChUb20gTGFuZSkKKyAgICAgPC9wYXJhPgorICAgIDwvbGlz dGl0ZW0+CisKICAgIDwvaXRlbWl6ZWRsaXN0PgogCiAgIDwvc2VjdDI+Cg== --------------3981EECDB536F5A9B923F485-- --M1nFr7bQRma1hvNFn0Gji8gH72qxPceCk-- --AU4ent38VKqGi4TFQST0zHS8RqAvQfzGT Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAl9g1yIACgkQ8QSccp8c ZSe2dhAArWrK/BHjnk0pijkzLkSY2zz5lfofQUOu9D40e8weF+0wFLIqnK5s7u7x 7YhJYtYGU34dg9D5O6HAThnkFpevI/Zb3jkQJCWZu46aQ6weJRKmarfp2EarcsKz g0kjxfWtnICYHG3dU0WnpSKA/vfwcrcox9WrR+mOvxP32XdaKeVPyk0q8Sl94lSN 1tePb3NENQelt2UM7JqRsF/+JSmXNIf6nKiXEtYqkiyNT6NiqkKggkNB1VdlGzgK PDNuzGtLu6z8Nv6H/t3fyPujfxoIuSQCiLMgG1AuckT36Rh9a0LRUfleSAx27DOo lu6ZSHRZj0vhDhaACR3QwSR7e1zq9+h70KaDsd+qekZq7wU+rEXwia4Qhcx5Ho5W BXAzoidC6bV0UOlqRLKMfDKuklkH7VlbLHUSOEEepKGdq0ZTJeY+46uYXRheEbAf rCeGUiyy9IMeQhApAmmwWqmwpYVFDxaGlILyjpl94nn4BuH9qXqeSfyMX++zw3y6 q14eCLfYk11ctUSyVaAp0khtOTi+pBi2nB5aDvQz46K5tw6Lv95p2vYhCwpMYl4u rbqYI3/cCmrOiVkXP1GbFokUoq2x3PDoFyyknb+Cl8yr/SqR0gjSwUpT91X5h4lu je5baOAmhjbOtwxRR/4NLs6pd/GUY01/Gd/KZb3gZOZEk3BqsPw= =M724 -----END PGP SIGNATURE----- --AU4ent38VKqGi4TFQST0zHS8RqAvQfzGT--