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 1hBnvq-00057W-NT for pgsql-docs@arkaria.postgresql.org; Wed, 03 Apr 2019 22:00:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hBnvp-0002aL-JI for pgsql-docs@arkaria.postgresql.org; Wed, 03 Apr 2019 22:00:29 +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 1hBnvp-0002VJ-0J for pgsql-docs@lists.postgresql.org; Wed, 03 Apr 2019 22:00:29 +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 1hBnvm-0005Dl-6Z for pgsql-docs@lists.postgresql.org; Wed, 03 Apr 2019 22:00:28 +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=JddkLmgtzs9M1GpkfDyY9p6fjWdVmNnv438HKLgN338=; b=L/dCOfJGqDbdYOOXYVsPC1VZ3u jGtI1ZwDAI8YETBFhtap6ePPq1DAlBBeKitM8LbuU8o/sCKt8H+/d/P0zmb2pygVu2vc2F/EJHUf4 xpekTX/Hwh12BiwOFR8V9oWN4ToKvegY5wgkSw9qmC1mkeGy3rMlsGkHo7Ra9/wCKaaB4rcpBlpJl Q8bt7V3O49JrH5Skq91gqC+H2e1de2dZ7hrVPfBwV8aPqqjSdNwlnc4gka/Kkbv41sz3iY3valV9U 8nTtJ4ruOLgbbIXM+FhL5BSSnn7NuZc8vUV9W7HA5f9L/68PGSKyY9BzV30uIpTGeSBUIhB4R4K9L NRpgwIfg==; 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 1hBnvi-0003Sl-BY; Wed, 03 Apr 2019 22:00:25 +0000 Subject: Re: Clarity in partial index example. To: droptablestar@gmail.com, pgsql-docs@lists.postgresql.org, PG Doc comments form References: <155432280882.722.12392985690846288230@wrigleys.postgresql.org> 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: Wed, 3 Apr 2019 18:00:18 -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: <155432280882.722.12392985690846288230@wrigleys.postgresql.org> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="FAZcPBfOVfgskdc69h7qk0q0jW26TRb7b" 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) --FAZcPBfOVfgskdc69h7qk0q0jW26TRb7b Content-Type: multipart/mixed; boundary="hCEuJGuyn6bsoJ6tQUfXRY6u2wD67rhrb"; protected-headers="v1" From: "Jonathan S. Katz" To: droptablestar@gmail.com, pgsql-docs@lists.postgresql.org, PG Doc comments form Message-ID: Subject: Re: Clarity in partial index example. References: <155432280882.722.12392985690846288230@wrigleys.postgresql.org> In-Reply-To: <155432280882.722.12392985690846288230@wrigleys.postgresql.org> --hCEuJGuyn6bsoJ6tQUfXRY6u2wD67rhrb Content-Type: multipart/mixed; boundary="------------B5A6BEF7D8F3B643D2368FCE" Content-Language: en-US This is a multi-part message in MIME format. --------------B5A6BEF7D8F3B643D2368FCE Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 4/3/19 4:20 PM, PG Doc comments form wrote: > The following documentation comment has been logged on the website: >=20 > Page: https://www.postgresql.org/docs/11/indexes-partial.html > Description: >=20 > The example illustrating when a partial index can and cannot be used is= a > little misleading. The query which can use the partial index is: > SELECT * > FROM access_log > WHERE url =3D '/index.html' AND client_ip =3D inet '212.78.10.32'; >=20 > and the query which can't use the partial index is: > SELECT * > FROM access_log > WHERE client_ip =3D inet '192.168.100.23'; >=20 > Maybe I am misunderstanding the concept here but url =3D '/index.html' = doesn't > have any effect on this? If that's the case I would suggest either remo= ving > it from the first query or adding it to the second query. You're correct, the url =3D '/index.html' does not affect if the partial index is used in the example. Based on how the example is set up, I'd propose using the "url" parameter in both examples. I've attached a patch that does this, with some additional wording around the examples. Thanks, Jonathan --------------B5A6BEF7D8F3B643D2368FCE Content-Type: text/plain; charset=UTF-8; x-mac-type="0"; x-mac-creator="0"; name="0001-Use-consistent-examples-of-queries-demonstrating-whe.patch" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename*0="0001-Use-consistent-examples-of-queries-demonstrating-whe.pa"; filename*1="tch" RnJvbSA5NzE5ODM1MWEwNjZmNDM4MjM1NzNmNzI4MDExMWQ3OGVlODg5NWU3IE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiAiSm9uYXRoYW4gUy4gS2F0eiIgPGpvbmF0aGFuLmth dHpAZXhjb3ZlbnR1cmVzLmNvbT4KRGF0ZTogV2VkLCAzIEFwciAyMDE5IDE3OjU4OjE3IC0w NDAwClN1YmplY3Q6IFtQQVRDSF0gVXNlIGNvbnNpc3RlbnQgZXhhbXBsZXMgb2YgcXVlcmll cyBkZW1vbnN0cmF0aW5nIHdoZW4gYQogcGFydGlhbCBpbmRleCBpcyB1c2VkLgoKLS0tCiBk b2Mvc3JjL3NnbWwvaW5kaWNlcy5zZ21sIHwgNiArKysrLS0KIDEgZmlsZSBjaGFuZ2VkLCA0 IGluc2VydGlvbnMoKyksIDIgZGVsZXRpb25zKC0pCgpkaWZmIC0tZ2l0IGEvZG9jL3NyYy9z Z21sL2luZGljZXMuc2dtbCBiL2RvYy9zcmMvc2dtbC9pbmRpY2VzLnNnbWwKaW5kZXggMzQ5 M2Y0ODJiOC4uOWEzZjZkOWI5ZSAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL2luZGljZXMu c2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvaW5kaWNlcy5zZ21sCkBAIC04MTQsMTEgKzgxNCwx MyBAQCBTRUxFQ1QgKgogRlJPTSBhY2Nlc3NfbG9nCiBXSEVSRSB1cmwgPSAnL2luZGV4Lmh0 bWwnIEFORCBjbGllbnRfaXAgPSBpbmV0ICcyMTIuNzguMTAuMzInOwogPC9wcm9ncmFtbGlz dGluZz4KLSAgICBBIHF1ZXJ5IHRoYXQgY2Fubm90IHVzZSB0aGlzIGluZGV4IGlzOgorICAg IGFzIHRoZSBhYm92ZSBJUCBhZGRyZXNzIGZhbGxzIGludG8gdGhlIHJhbmdlIHRoYXQgaXMg Y292ZXJlZCBieSB0aGUgcGFydGlhbAorICAgIGluZGV4LiBUaGUgZm9sbG93aW5nIHF1ZXJ5 IGNhbm5vdCB1c2UgdGhlIHBhcnRpYWwgYXMgaXQgdXNlcyBhbiBJUCBhZGRyZXNzCisgICAg dGhhdCBpcyBvdXRzaWRlIHRoZSByYW5nZSBvZiB0aGUgcGFydGlhbCBpbmRleDoKIDxwcm9n cmFtbGlzdGluZz4KIFNFTEVDVCAqCiBGUk9NIGFjY2Vzc19sb2cKLVdIRVJFIGNsaWVudF9p cCA9IGluZXQgJzE5Mi4xNjguMTAwLjIzJzsKK1dIRVJFIHVybCA9ICcvaW5kZXguaHRtbCcg QU5EIGNsaWVudF9pcCA9IGluZXQgJzE5Mi4xNjguMTAwLjIzJzsKIDwvcHJvZ3JhbWxpc3Rp bmc+CiAgICA8L3BhcmE+CiAKLS0gCjIuMTQuMyAoQXBwbGUgR2l0LTk4KQoK --------------B5A6BEF7D8F3B643D2368FCE-- --hCEuJGuyn6bsoJ6tQUfXRY6u2wD67rhrb-- --FAZcPBfOVfgskdc69h7qk0q0jW26TRb7b Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAlylLPIACgkQ8QSccp8c ZScjeQ//VS8qO07uhvtXMBK6b0ci2yIdfiVzGQ9cynplqw0cZPLJQLcq+DRRwF6m sfPE47M7m2nIPLlElbfzmB7d1xdvZam7jlX07Ps5boAknuKg/h6VblZ7R0zPW+Tj BWWekYIqMoAMjUuki9ET2wXLXrNlJhsnNveHmqnc2GLhDQgYvvp+RxOFopy3gPRk 387Y48D2Nc+ACOIoTrE8W6PKcQfgo6pgtllr9jn2ChxJHQcpIml0LoTAFSpJoL85 B25XAlcNK+OfJBgezZdFvEDnzy8tDV5Z4bK9cu1wlPb5s89fVluuYew61LTl5rDN w+/wvoZY6ZRoFtabAYcLLm+YuKTNEJs+kGoT9Qi+8u63htu22L4DW+Rjxj/0Jpxg VNDs08CqRkVrATBPe25bYERXA3tXV++W7toBewjpRAOoE1Tzu4/5EhxQf3UibD4w /yRIZRcuTExEGDwj0x7xDwuOVIEBSbQm2XciF70NDXLLLvPRy/SPPHr+eOQgdrLO BYJS8+ExK0Iu/ae6tBA5Fh0Exs1BJNgwwvHfhL008IER0bFrnKOeha4qsl+SrCPo TunB+S1hOb2Z/336gthOIaxT1EkewV+x6N+f86w8udYfKKbRrKe8J7Lcl2zEM6xq 1THSbwKpG3kSmWEQ+e02NuMuyhHOtPkpdL8+LkqR0n+JlJ89FrQ= =FlzI -----END PGP SIGNATURE----- --FAZcPBfOVfgskdc69h7qk0q0jW26TRb7b--