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 1gtyrA-0002oa-0x for pgsql-www@arkaria.postgresql.org; Wed, 13 Feb 2019 18:02:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gtyr7-00020c-PN for pgsql-www@arkaria.postgresql.org; Wed, 13 Feb 2019 18:01:57 +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 1gtyr7-00020V-GL for pgsql-www@lists.postgresql.org; Wed, 13 Feb 2019 18:01:57 +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.89) (envelope-from ) id 1gtyr4-0005yQ-7T for pgsql-www@lists.postgresql.org; Wed, 13 Feb 2019 18:01:56 +0000 Received: from [63.118.15.50] (helo=Ph33r-Retina.local) by meldrar.postgresql.org with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gtyr0-0000p9-0F; Wed, 13 Feb 2019 18:01:52 +0000 Subject: Re: Release Notes Archive Patch To: Tom Lane Cc: "pgsql-www@lists.postgresql.org" References: <751cae66-4d83-5012-94c6-b915bfa03f9e@postgresql.org> <23227.1550070811@sss.pgh.pa.us> <81313189-2e85-062a-f6d9-620298b4b00e@postgresql.org> <25885.1550074702@sss.pgh.pa.us> 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: <5ab20e2d-f291-51db-6761-07daeed5a87a@postgresql.org> Date: Wed, 13 Feb 2019 13:01:46 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:60.0) Gecko/20100101 Thunderbird/60.5.0 MIME-Version: 1.0 In-Reply-To: <25885.1550074702@sss.pgh.pa.us> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="NSCMFvpurWIUz7diJsBs0tnCzGl4F6lSG" X-Host-Lookup-Failed: Reverse DNS lookup failed for 63.118.15.50 (failed) 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) --NSCMFvpurWIUz7diJsBs0tnCzGl4F6lSG Content-Type: multipart/mixed; boundary="BWPRyg4tQYAQ1qGNgw97LMuqaVfCXgToe"; protected-headers="v1" From: "Jonathan S. Katz" To: Tom Lane Cc: "pgsql-www@lists.postgresql.org" Message-ID: <5ab20e2d-f291-51db-6761-07daeed5a87a@postgresql.org> Subject: Re: Release Notes Archive Patch References: <751cae66-4d83-5012-94c6-b915bfa03f9e@postgresql.org> <23227.1550070811@sss.pgh.pa.us> <81313189-2e85-062a-f6d9-620298b4b00e@postgresql.org> <25885.1550074702@sss.pgh.pa.us> In-Reply-To: <25885.1550074702@sss.pgh.pa.us> --BWPRyg4tQYAQ1qGNgw97LMuqaVfCXgToe Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable On 2/13/19 11:18 AM, Tom Lane wrote: > "Jonathan S. Katz" writes: >> On 2/13/19 10:13 AM, Tom Lane wrote: >>> The patch doesn't convey a lot to my mind, so I have to ask: exactly >>> what URLs would this present? >=20 >> I'm a bit confuse by the question, so I'll answer it from two angles. >=20 > Neither of those are quite what I meant. As I understood Andres' > complaint, it was that right now we have URLs like >=20 > https://www.postgresql.org/docs/10/release-9-6-5.html >=20 > but those are going to be 404 beginning tomorrow. It sounds from your > response like this patch isn't meant to restore those cross-version URL= s. > Which is fine by me, really, but we might get pushback about it. If so= , > there might be material for follow-on work to redirect those into this > new set of URLs Thanks for clarifying! So, in anticipation of push back, I also want to provide some stats. I looked at overall traffic since Jul 1, 2018 to yesterday. Traffic to any of the release notes in general was a very small chunk of it (< 0.5%). When just looking at the subset of release notes, the top 5 receivers wer= e: 1. 11.0 2. 10.5 3. 10.4 4. "current/static/release.html" 5. 9.6 release index This constituted a little over 35% of the overall release note traffic. My inferences are that people tend to go to the release notes for the "latest" release. Now, in terms of things like "/docs/9.5/9-4-19.html" and the like, the only one that had significant traffic was /docs/9.6/static/release-9-5.html, and that was #25 on the list (the notes coming before it accounting for 60%+ of the traffic). In fact, I did not see another of the "mismatch" URLs until #37 on the list, which was /docs/10/static/release-9-5.html =46rom a user experience perspective, does it stink that we're potentiall= y creating a bunch of 404s? Yes. Is it going to upset some people? Yes, and I'm sympathetic to that. However, looking at the overall numbers, I think we'll be ok, even if we don't have the redirects per Magnus' suggestion downthread (which I will also reply to). >=20 >> WRT loading the release notes themselves, basically it is using the da= ta >> found in the current doc imports. Often in the release notes, there ar= e >> URLs either to older release notes (like in the top line) or various >> features/sections of the documentation (e.g. a GUC, a SQL command, etc= =2E) >=20 > Right. The latter type will link to the main docs for the associated > release, correct? Correct. Thanks, Jonathan --BWPRyg4tQYAQ1qGNgw97LMuqaVfCXgToe-- --NSCMFvpurWIUz7diJsBs0tnCzGl4F6lSG Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAlxkW4oACgkQ8QSccp8c ZSdwrg/+Na8SraVE8WpjlIMl0Wt1UrrkQhVGeYeP7iN5F7mwpH7tyS/Fk5n7aS+J L1MMqgJ+0HLQf4ZEdnhPrKIETzIJnBWNYyKUzHlGGovBpUP/FnQXxwh4KanfzqDH Q1NPX5Vv2pr82Sy5ENsIEll9aONQ/mBtCepRxruLx5ZBqNnwJVuJi62NtJJg8WCA KfU6i77kBz6/2cXsdx+bD956KZcw9aVePDkMxu5RXUWm/iUCF4NHC5dRKWm+YihM LIEkAshwyMRfCutchyGrZ8MpHIJKAJocLz34K/OZGLutZ5jZp1Nqy8kb9QrZgMg1 iQLGfbS9tZ25vYHSao+eFJNjegw50eEIOEPRziKxcx9vpKhXmjFa9hu29z0ffNS8 YpNQl615HUv9Dd+Xg7tURiBDobKOpHrBWqE6pZBIx7GI18QuFtNSfxq176QxklQz bM01u7B+yfWQx1HjX9iilyzERIU80OI8Njnuiqm9XAzwvtXU0w7GRf0PvaqyWSTz NNnybV7ri58o3NB+i8+u2Js1kifwcPCBOgnZD8syZsLo5R7ErY9kVXLt0sov8zcc 03DBptC1J+f4mkCu+OiyIfRbWImLwKpGzeetArpMstFthXhkUPxIFLL4Dvzeh3ws 9eI1tfZgSROAQiE5QV2m223oA7mAYjsqEMHgLyUMUcq9qoQ+m/E= =AF0/ -----END PGP SIGNATURE----- --NSCMFvpurWIUz7diJsBs0tnCzGl4F6lSG--