Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9489A9F99D5 for ; Thu, 1 Nov 2007 19:07:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 76423-01 for ; Thu, 1 Nov 2007 19:07:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from svr2.hagander.net (svr2.hagander.net [88.198.128.226]) by postgresql.org (Postfix) with ESMTP id E2E6F9FC5CD for ; Thu, 1 Nov 2007 18:51:57 -0300 (ADT) Received: from dynamic.hagander.net ([127.0.0.1]) (encrypted and authenticated) by svr2.hagander.net (Postfix) with ESMTP id BC3D7DCC9AE; Thu, 1 Nov 2007 22:51:55 +0100 (CET) Message-ID: <472A4A86.6000307@hagander.net> Date: Thu, 01 Nov 2007 22:52:06 +0100 From: Magnus Hagander User-Agent: Thunderbird 2.0.0.6 (X11/20070728) MIME-Version: 1.0 To: Tom Lane CC: "Marc G. Fournier" , Andrew Sullivan , pgsql-www@postgresql.org Subject: Re: what is up with the PG mailing lists? References: <25716.1193887595@sss.pgh.pa.us> <26669.1193891360@sss.pgh.pa.us> <47299585.7030402@hagander.net> <47299957.5020605@postgresql.org> <2968.1193919208@sss.pgh.pa.us> <20071101080959.49f3087b@scratch> <20071101152333.GM27676@crankycanuck.ca> <4729F105.30704@hagander.net> <1127E6493CBA8A29F343C4D7@ganymede.hub.org> <4729F7D2.6050608@hagander.net> <472A37FD.60501@hagander.net> <15696.1193952675@sss.pgh.pa.us> In-Reply-To: <15696.1193952675@sss.pgh.pa.us> X-Enigmail-Version: 0.95.5 Content-Type: multipart/mixed; boundary="------------060608060500000404030309" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/48 X-Sequence-Number: 12826 This is a multi-part message in MIME format. --------------060608060500000404030309 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Tom Lane wrote: > Magnus Hagander writes: >> Oh, and the headers I sent were because the email was stuck in the >> moderation queue. > > Yeah --- one of the worst problems in diagnosing this is that there's > no way for anyone except the moderator to know if a delay was simply > waiting-for-moderation or if it indicates an actual system problem. > > What are the chances of getting something into the headers to indicate > whether a message was delayed by moderation? Not sure - Marc? You're the one who know majordomo... Anyway, I just ran a script on all the mail sitting in my mailbox from postgresql mailinglists delivered in the past two hours. It's a total of 22 mails (should be more, I know - but I need to deal with differences in date before I get there, this is a first rough cut of the script). Here's the top lines from the query: select path,count(*),avg(t)::int from data group by path order by 2 desc,3 desc; on this data. Basically, it's the paths that appear often, and the average delivery time between them (in seconds). I've only included paths that appear 7 or more times, plus the two rows for mails posted by Tom and me (there are others that appear twice as well, but I'm not including those). This is all delivery to me, which is why the path mx2.hub.org->svr2.hagander.net and svr2.hagander.net->svr2.hagander.net (my antispam) is included. path | count | avg ---------------------------------------------------------------------------------------+-------+------ postgresql.org -> mx2.hub.org | 22 | 57 svr2.hagander.net -> svr2.hagander.net | 22 | 1 mx2.hub.org -> svr2.hagander.net | 22 | 1 postgresql.org -> localhost (mx1.hub.org [200.46.204.184]) | 15 | 3335 localhost (mx1.hub.org [200.46.204.184]) -> postgresql.org | 15 | 23 postgresql.org -> localhost (mx1.hub.org [200.46.204.183]) | 7 | 2710 localhost (mx1.hub.org [200.46.204.183]) -> postgresql.org | 7 | 17 sss.pgh.pa.us (8.14.1/8.14.1) -> postgresql.org | 3 | 8 svr2.hagander.net -> postgresql.org | 2 | 2 (sorry about the breakup of the table, it's the long lines for mx1.hub.org. Table attached as well for easier reading) To me this clearly shows that mail is backed up between postgresql.org (this is svr1, if I'm not mistaken) and mx1.hub.org - which has two different IPs, but claims to be localhost (that can't be right, can it?). FYI, the count measures the difference in time between the Received: lines in the header. It's not fool-proof, but it works on all the paths inside hub.org and from there to my machine - it misses some originating MUAs (it's missed 2 out of the 22 emails parsed here) //Magnus --------------060608060500000404030309 Content-Type: text/plain; name="mail_delays.txt" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="mail_delays.txt" path | count | avg ---------------------------------------------------------------------------------------+-------+------ postgresql.org -> mx2.hub.org | 22 | 57 svr2.hagander.net -> svr2.hagander.net | 22 | 1 mx2.hub.org -> svr2.hagander.net | 22 | 1 postgresql.org -> localhost (mx1.hub.org [200.46.204.184]) | 15 | 3335 localhost (mx1.hub.org [200.46.204.184]) -> postgresql.org | 15 | 23 postgresql.org -> localhost (mx1.hub.org [200.46.204.183]) | 7 | 2710 localhost (mx1.hub.org [200.46.204.183]) -> postgresql.org | 7 | 17 sss.pgh.pa.us (8.14.1/8.14.1) -> postgresql.org | 3 | 8 svr2.hagander.net -> postgresql.org | 2 | 2 --------------060608060500000404030309--