Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 0B00F9FB3E9; Fri, 13 Apr 2007 17:25:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 65660-02; Fri, 13 Apr 2007 17:25:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 02B919FB2D9; Fri, 13 Apr 2007 17:25:18 -0300 (ADT) Received: from perhan.alvh.no-ip.org (201-221-221-161.bk12-dsl.surnet.cl [201.221.221.161]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l3DKPJ85013108; Fri, 13 Apr 2007 13:25:19 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 1BCFD329F6; Fri, 13 Apr 2007 16:25:15 -0400 (CLT) Date: Fri, 13 Apr 2007 16:25:15 -0400 From: Alvaro Herrera To: "Marc G. Fournier" Cc: Dave Page , Tom Lane , pgsql-www@postgresql.org Subject: Re: [whine] Slow moderation on postgres lists Message-ID: <20070413202515.GE27255@alvh.no-ip.org> References: <7550.1176268648@sss.pgh.pa.us> <461C918A.4040701@postgresql.org> <20070411130340.GB4896@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Fri, 13 Apr 2007 13:25:20 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/80 X-Sequence-Number: 11830 Marc G. Fournier wrote: > I login to the web interface, as 'ALL' (so all lists are presented), then > middle click on the posting itself so that it opens it in a new tab, and > quickly go through an approve all the ones that need to be approved, skipping > then ones that don't ... then i Use the 'select all' checkbox and > 'reject-quiet' all the rest (minus the subscribe/unsubscribe requests, which > just sit in the queue to expire or be accepted by the subscriber) ... Ouch, I tried this in the past and found it really annoying. > I don't do anything via email ... much too slow / painful ... Yeah, I take exactly two seconds for each email. No browser, no nothing, just a single keypress for each moderation request. Way too slow. Now I understand why Greg talked about the need to "run the moderation on his own schedule". If you're gonna take fifteen minutes to do it, sure, you don't want to interrupt your normal email flow. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support