Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 31C5B9FB2C1; Fri, 13 Apr 2007 17:20:44 -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 01164-07; Fri, 13 Apr 2007 17:20:37 -0300 (ADT) Received: from hub.org (hub.org [200.46.204.220]) by postgresql.org (Postfix) with ESMTP id A12069FB2D4; Fri, 13 Apr 2007 17:20:40 -0300 (ADT) Received: from localhost (unknown [200.46.204.183]) by hub.org (Postfix) with ESMTP id B0E5985C901; Fri, 13 Apr 2007 17:20:37 -0300 (ADT) Received: from hub.org ([200.46.204.220]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 74941-02; Fri, 13 Apr 2007 17:20:37 -0300 (ADT) Received: from ganymede.hub.org (blk-89-241-126.eastlink.ca [24.89.241.126]) by hub.org (Postfix) with ESMTP id 4D8DD85C8FE; Fri, 13 Apr 2007 17:20:34 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 4918B5CFEB; Fri, 13 Apr 2007 17:20:39 -0300 (ADT) Date: Fri, 13 Apr 2007 17:20:39 -0300 From: "Marc G. Fournier" To: Alvaro Herrera , Dave Page cc: Tom Lane , pgsql-www@postgresql.org Subject: Re: [whine] Slow moderation on postgres lists Message-ID: In-Reply-To: <20070411130340.GB4896@alvh.no-ip.org> References: <7550.1176268648@sss.pgh.pa.us> <461C918A.4040701@postgresql.org> <20070411130340.GB4896@alvh.no-ip.org> X-Mailer: Mulberry/4.0.7 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/79 X-Sequence-Number: 11829 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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) ... I don't do anything via email ... much too slow / painful ... - --On Wednesday, April 11, 2007 09:03:40 -0400 Alvaro Herrera wrote: > Dave Page wrote: >> Tom Lane wrote: >> > I thought we had things set up so that there were multiple people >> > moderating the postgres mail lists, but it seems like the average time >> > to approve postings from unsubscribed folk has slid back down to the >> > two-or-three-day range :-(. What can be done to improve that? Maybe >> > recruit a few more moderators? >> >> Which lists are slow? I tend to moderate in real time whilst I'm awake, >> or at least the next time I check my mail when not (which is invariably >> only a few hours away). I can probably add another couple to my list if >> that would help. > > What do people use to moderate? Are there any scripts to help or > something? I've seen people wasting time hitting reply, writing > "accept", etc, which consumes a lot of time. (FWIW I do have a script, > which currently only works for pgsql-es-ayuda but I think it could be > easily generalized). > > -- > Alvaro Herrera http://www.CommandPrompt.com/ > PostgreSQL Replication, Consulting, Custom Development, 24x7 support > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match - ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . scrappy@hub.org MSN . scrappy@hub.org Yahoo . yscrappy Skype: hub.org ICQ . 7615664 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (FreeBSD) iD8DBQFGH+YX4QvfyHIvDvMRAhDqAKCeHthbrj8Xlv1DJpedw1i7tMVGcgCgwsh0 o9Cb6099ENeyqwG+mS5ivJY= =WtIU -----END PGP SIGNATURE-----