Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ubP9c-000Or8-HQ for pgsql-www@arkaria.postgresql.org; Mon, 14 Jul 2025 19:48:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ubP9a-00Cnx2-KX for pgsql-www@arkaria.postgresql.org; Mon, 14 Jul 2025 19:47:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ubP9a-00Cnwu-Bg for pgsql-www@lists.postgresql.org; Mon, 14 Jul 2025 19:47:59 +0000 Received: from mail-yb1-xb31.google.com ([2607:f8b0:4864:20::b31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ubP9Y-007i6q-0m for pgsql-www@postgresql.org; Mon, 14 Jul 2025 19:47:58 +0000 Received: by mail-yb1-xb31.google.com with SMTP id 3f1490d57ef6-e75668006b9so4718646276.3 for ; Mon, 14 Jul 2025 12:47:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hagander.net; s=mail; t=1752522474; x=1753127274; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=iD/Jn8eSXCcUUGp+U+0Qp4lwt8PccgGRQ+p3xoNgUpk=; b=GmxnvsxPYe9tP7/TPKZhz9qJfeje4smh/hcwlYJk7Cpvyia99cT0T3lVsYwBh/0pOY C0BIf5XoBSJ8Ec2qPnoAC7uETqF1xyHIqmg3PN0P7K/uOxLNowMf74/0ZFAEtK+Wbzip 3wQ76ysI481iP/eXFtxv4uAoaCYWAReLAUfLkWw0AEZkRynnxUAeEuH9guk5bj1jOtKo p6At5ZN3cWVY6dXvKFnPjh8NpVm+MQpFVLqHGmQi6hwPbctZlp5BmUaNVoChZ+YYznsl fcWNxKMo1/717xaU+AFxTzbW9/qIPzPOygFnDzBM4qXblwtdl1LEZGoE8BrECHfzIeYC s3IA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1752522474; x=1753127274; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=iD/Jn8eSXCcUUGp+U+0Qp4lwt8PccgGRQ+p3xoNgUpk=; b=Qi/pQo/ljQczkYVY5kVE4OyIf4emnBfjFxRHVHpbyHib9BEMmcuyFDIrAWctxFG7Od h9Yeh1VYDXFy2HIOLRv/ke+iN/MkRj733hG50iOopGW4KPg7BJrbqpcxZhZsgEmLLbrG p9u0p0TmRAzm4k/MDsi7pwNzb0mJrLqc2nZ4bgkn/4rSEoVBrcZLbYwVVxMQ4UsP0HCi Wp/It+8NcexKkOU0JpC1uEIobnERyzngJT+SP2557RNI2b9AvBsa+mU0/Mtn+/qpH1vH Q1850ktYt4Ck68GgEB046wAD8NSt4EYxfhAdMZRlEPw06h8qOB8T/yYgmrrcYePQJGtC wewA== X-Gm-Message-State: AOJu0Yza86B+t5Po62gNPA91+w+unnnrX2jw4PhZHHaFMsydIzS290BE HC7tFetW6KPsz9xU2gJWdoOJgAOu1nPWNW8CrnB7Vglap0iExZZVX+tEBdihMHJ7cgXvm7NuUoJ GchWFO3/X4UVmF0o6uY9i3XpbmwrUkKSmDXj32BbP X-Gm-Gg: ASbGncs5AfT7VNMKm7wGXzygHYEY9UURiqajBF9CYnO6XqAY2sHZSAjhVxBxZOMZS2I F6jWihjItakaEx2C8xseLhz95KpVwSovWxdfCaY7e3fCt+noRRaW7ixPee1QRuV5DEAkQHlXs9t iCsMgJZG03RT3/h7OidnnZNUkzvIvuGYZvh+WlEFE/N87gPDHPRak9utSeFwVSv3gBsrFfh7KYx FNEqeCqr/fVZRLrCPckX/cY34KndCaVaP+lpvdzcz398Qs4v6Oj X-Google-Smtp-Source: AGHT+IEuEoJU4zcm/+xIgDczwvGdYzAC4qm8ffjB2PDtjA/2r4gkeV09KWRNf9pQevbUKun0bwE9Fx1jtav3S0Z28gM= X-Received: by 2002:a05:690c:9a01:b0:712:e2b5:e61b with SMTP id 00721157ae682-717d78c65b9mr232084177b3.13.1752522473932; Mon, 14 Jul 2025 12:47:53 -0700 (PDT) MIME-Version: 1.0 References: <20250714194351.e9.nmisch@google.com> In-Reply-To: <20250714194351.e9.nmisch@google.com> From: Magnus Hagander Date: Mon, 14 Jul 2025 21:47:42 +0200 X-Gm-Features: Ac12FXy2x9T_ryGZKtVaY7nV3dLcIxDRvorq1P-qBBhh6NJ19qqjxZcBGkLtfpA Message-ID: Subject: Re: List archives "Next" button new behavior To: Noah Misch Cc: pgsql-www@postgresql.org Content-Type: multipart/alternative; boundary="000000000000851c960639e8ef67" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000851c960639e8ef67 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Jul 14, 2025 at 9:43=E2=80=AFPM Noah Misch wrot= e: > A few weeks ago, the "Next" button on pages like > https://www.postgresql.org/list/pgsql-www/since/202507100000 changed > behavior: > > Old behavior: "Next" would use the timestamp of the newest message as of > when > you last loaded the page. "Next" would take you to a page containing tha= t > timestamp and all newer-timestamp messages. For example, as I'm writing > this, > the newest message has timestamp 2025-07-10T14:03. "Next" used to take m= e > to > https://www.postgresql.org/list/pgsql-www/since/202507101403 and I'd then > see > the 14:03 message and later messages, if any. > > New behavior: As long as the latest message is from 2025-07-10, "Next" > takes > one to https://www.postgresql.org/list/pgsql-www/since/202507100000. > Also, > visiting https://www.postgresql.org/list/pgsql-www/since/202507101403 > redirects to 202507100000 (zeroing the HH:MM from the request). > > (I'm simplifying; there are more behavior nuances if one starts at a date > far > enough in the past for messages to fill the page.) > > Does anyone have background on this change? I found no discussion of it. > > I liked the old behavior better, since it made the "Next" button > convenient to > see everything since I last caught up. That said, I'll adapt if the > change is > intentional and/or favored. > Yes. The problem with the old more detailed URLs is that in practice it generated an infinite number of URLs for AI bots to crawl, and they did. We got a constant load of a few hundred bot hits per second just looking at those indexes. Because AI is the future.... --=20 Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/ --000000000000851c960639e8ef67 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Mon, Jul 14,= 2025 at 9:43=E2=80=AFPM Noah Misch <noah@leadboat.com> wrote:
A few weeks ago, the "Next" button on pages li= ke
https://www.postgresql.org/list/pgsql-ww= w/since/202507100000 changed
behavior:

Old behavior: "Next" would use the timestamp of the newest messag= e as of when
you last loaded the page.=C2=A0 "Next" would take you to a page c= ontaining that
timestamp and all newer-timestamp messages.=C2=A0 For example, as I'm w= riting this,
the newest message has timestamp 2025-07-10T14:03.=C2=A0 "Next" u= sed to take me to
https://www.postgresql.org/list/pgsql-ww= w/since/202507101403 and I'd then see
the 14:03 message and later messages, if any.

New behavior: As long as the latest message is from 2025-07-10, "Next&= quot; takes
one to https://www.postgresql.org/list/p= gsql-www/since/202507100000.=C2=A0 Also,
visiting https://www.postgresql.org/list= /pgsql-www/since/202507101403
redirects to 202507100000 (zeroing the HH:MM from the request).

(I'm simplifying; there are more behavior nuances if one starts at a da= te far
enough in the past for messages to fill the page.)

Does anyone have background on this change?=C2=A0 I found no discussion of = it.

I liked the old behavior better, since it made the "Next" button = convenient to
see everything since I last caught up.=C2=A0 That said, I'll adapt if t= he change is
intentional and/or favored.

Yes. The pr= oblem with the old more detailed URLs is that in practice it generated an i= nfinite number of URLs for AI bots to crawl, and they did. We got a constan= t load of a few hundred bot hits per second just looking at those indexes. = Because AI is the future....
=C2=A0
--
=C2=A0Magnus Hagander
=C2=A0Me: https://www.hagander.net/
= =C2=A0Work: ht= tps://www.redpill-linpro.com/
--000000000000851c960639e8ef67--