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 1n98iD-00079p-J3 for pgsql-www@arkaria.postgresql.org; Sun, 16 Jan 2022 16:49:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n98iC-0003sS-G4 for pgsql-www@arkaria.postgresql.org; Sun, 16 Jan 2022 16:49:00 +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 1n98iC-0003sJ-6b for pgsql-www@lists.postgresql.org; Sun, 16 Jan 2022 16:49:00 +0000 Received: from mail-io1-xd31.google.com ([2607:f8b0:4864:20::d31]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n98i9-0000OT-2Q for pgsql-www@postgresql.org; Sun, 16 Jan 2022 16:48:59 +0000 Received: by mail-io1-xd31.google.com with SMTP id o9so8323431iob.3 for ; Sun, 16 Jan 2022 08:48:56 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=H85ddtvOX3GaXnWnffIEmYzwDBy741rfVsj2//8v9LA=; b=mhEclVAQR5Dw3R+xI6F1W/gvf3rbuflX0d9cAMnZdvXQhQ+L6qy/pRVIwljrxwH5FL NZ0ovTUOOQtCLnuod9d5tv9j4lQfTbc/Qv7JQLdh6mBFiUw/Ln3jb1aYdOBJ3o1AwAJZ MymQnMeqEROzlX/LCK7thOqZx2mVYx4atSDNhTlTWNDVuMUaL8WkK0Y/DODkAJFxlKnr DAPSS3R5Eo6JhD69H2VBuRBoz77uKXDf9vzjBkv3PwvAHTTHXRgmJRp/uBzaovV5zIsg 4cV9NY1eppblnzIOZDlTZSMWLFuUOFztdmAfaEvUwmfQUmSa33F8mXetYY/v6YRK/RqX bXlg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=H85ddtvOX3GaXnWnffIEmYzwDBy741rfVsj2//8v9LA=; b=wcwR7i1cR+AEaDYGkcpGeZfk8Yq1nM1MfMyp5QiAkYU/ULyJQLQDwsBAAQLUL1XArY 0C5zlnREB6Ag3euaieSr7ZVJaQJ5HRyuu3a+GBIwChr6Sr1sI8NAt9F0nc5yykimHu1f PtH/NbKrn1JZQuZNh1uMLHl4avG4BjKUuJa7BreuhqeumUZYqt/zpEBcWxQvB68hC54z Y/6jAPTshufQ9aDWIHMOD8/+ZyxWXAwNqiR7tx/5BcnZmXrSA7tiobzAgaXj8eEzlxnb eIT8vlk7kVNzbUOHkTVyC434IOe/55z+8hS2Gtz8sV+hdnt/nGqH4rxqFhod8y3vPCZi pQcA== X-Gm-Message-State: AOAM530ftqifYUt+xXYWPZEC1N/Ml/0kLJ0zLaXhyWavePPigX9aaFlb fPoxg38vz5lNrOyfTgqnV77HIhghOspY9Q== X-Google-Smtp-Source: ABdhPJzGarzVWe+kWJIq/7bwWjfF0BTr0WO2Qc+uV/WBVFRWDrvu6rxVpWJI2pSNG0tsVKpB5NFrkQ== X-Received: by 2002:a05:6638:3049:: with SMTP id u9mr7801848jak.132.1642351734970; Sun, 16 Jan 2022 08:48:54 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id w6sm7777860ilv.18.2022.01.16.08.48.54 for (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 16 Jan 2022 08:48:54 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id B4F16800783; Sun, 16 Jan 2022 10:48:53 -0600 (CST) Date: Sun, 16 Jan 2022 10:48:53 -0600 From: Justin Pryzby To: pgsql-www@postgresql.org Subject: Re: order of messages on www.p.o/list Message-ID: <20220116164853.GA4336@telsasoft.com> References: <20190221185641.GB24667@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20190221185641.GB24667@telsasoft.com> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Checking back. This is still an issue. The web list archives seems to sort things by the MUA's "Date" header (??) without normalizing the timezones. When I refresh the page, I expect the newer messages to show up at the bottom. It should be "append-mostly". But with good consistency I see messages shift around in both directions, and it makes this a less useful/efficient way to follow the list. On Thu, Feb 21, 2019 at 12:56:41PM -0600, Justin Pryzby wrote: > Hi, > > I'm interested to follow PG development but -hackers is too noisy for me to > subscribe. I tried following the list on www page few times per day. However, > sometimes I refresh the page, and I see that new mails have arrived somewhere > in the middle (above the bottom mail), and I don't know which. So I either > lose time rereading list of mails (and mails themselves) or otherwise I miss > mails which showed up somehere in the middle.. > > I'm refering to a page like this: > https://www.postgresql.org/list/pgsql-hackers/since/201902210000/ > > Is that list ordered by time accounting for timezone ? For example if someone > in -11:00 sends a message at 14:00 UTC, does their message show up above somone > else in -04:00 who mails at 13:00 UTC ? Because their "Date:" header says > 03:00. > > Or perhaps it's an issue of the RFC822 "Date:" header vs. the received date? > All the headers are just annotations, and so I suggest the page should be > ordered not by the "date:" header set by the remote MUA but by the date in the > most recent "Received:" header, added by the local MTA. That avoids issue of > wrong time setting on remote side.