Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 508EA9FB1F4 for ; Thu, 1 Nov 2007 12:23:48 -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 12019-02 for ; Thu, 1 Nov 2007 12:23:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id F09429F9F92 for ; Thu, 1 Nov 2007 12:23:38 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1InbtS-0002Q1-BD for pgsql-www@postgresql.org; Thu, 01 Nov 2007 11:23:38 -0400 Received: by crankycanuck.ca (Postfix, from userid 1000) id 1ED084050; Thu, 1 Nov 2007 11:23:33 -0400 (EDT) Date: Thu, 1 Nov 2007 11:23:33 -0400 From: Andrew Sullivan To: pgsql-www@postgresql.org Subject: Re: what is up with the PG mailing lists? Message-ID: <20071101152333.GM27676@crankycanuck.ca> 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> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20071101080959.49f3087b@scratch> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/28 X-Sequence-Number: 12806 On Thu, Nov 01, 2007 at 08:09:59AM -0700, Joshua D. Drake wrote: > However the "mailing list" problem is a constant. Sometimes they work, > sometimes I don't get messages for hours. This is not the first time I > or others have brought up the mailing list issues. There are indeed sometimes mailing list latency issues. But I caution everyone in being too glib about some of this: 1. All the mail RFCs are totally clear that latency is to be expected in the mail system. Every time I hear complaints about mail latency that entails delays of merely hours, I worry that people are treating SMTP as though it's XMPP. It ain't, and it's designed _not_ to be. 2. There are plenty of individual relays involved here, and saying "it's slow" without mail headers is no more helpful in demystifying mail issues than are posts to -performance without EXPLAIN ANALYSE output. 3. We know that sometimes, moderation _does_ cost. This is especially true because we've already cranked up a lot of rules to capture common abuses (spam, common admin keywords) that are far from free to run on lists with the volume of mail the postgres lists get. So we're really paying for two moderations: humans, and machines. > It would be great if the actual sysadmin team had management ability on > the mail servers. This seems true to me. More important, > Note we still don't have documentation on this stuff I think this is a very serious problem. Some of the issues have been perplexing to diagnose because of the poor documentation. We talked about this most recently with respect to MX records and higher-preference-number MXes having the user list from the final destination, so that we could generate rejects consistently, IIRC. A -- Andrew Sullivan | ajs@crankycanuck.ca