Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1USDNj-0006Ii-9c for pgsql-www@arkaria.postgresql.org; Tue, 16 Apr 2013 21:25:39 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1USDNi-00047R-Ov for pgsql-www@arkaria.postgresql.org; Tue, 16 Apr 2013 21:25:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1USDNi-00047L-26 for pgsql-www@postgresql.org; Tue, 16 Apr 2013 21:25:38 +0000 Received: from cronos.madness.at ([2a02:16a8:dc41::10]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1USDNe-0002uF-Jb for pgsql-www@postgresql.org; Tue, 16 Apr 2013 21:25:37 +0000 Received: from mastermind.kaltenbrunner.cc ([2001:470:7a2d::22]) by cronos.madness.at with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.72) (envelope-from ) id 1USDNV-00041o-E6; Tue, 16 Apr 2013 23:25:27 +0200 Message-ID: <516DC1C4.5050808@kaltenbrunner.cc> Date: Tue, 16 Apr 2013 23:25:24 +0200 From: Stefan Kaltenbrunner User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130329 Thunderbird/17.0.5 MIME-Version: 1.0 To: Magnus Hagander CC: "Jonathan S. Katz" , Alvaro Herrera , Bruce Momjian , Josh Berkus , PostgreSQL WWW Subject: Re: Stalled news about ora2pg 11 on pg.org References: <516C4833.2050805@dalibo.info> <516C5A96.4020006@agliodbs.com> <20130415195918.GA4602@momjian.us> <20130415201046.GD8626@eldon.alvh.no-ip.org> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-www Precedence: bulk Sender: pgsql-www-owner@postgresql.org On 04/16/2013 09:10 AM, Magnus Hagander wrote: > On Tue, Apr 16, 2013 at 12:58 AM, Jonathan S. Katz > wrote: >> On Apr 15, 2013, at 4:19 PM, Magnus Hagander wrote: >> >>> On Mon, Apr 15, 2013 at 10:10 PM, Alvaro Herrera >>> wrote: >>>> Magnus Hagander wrote: >>>>> On Mon, Apr 15, 2013 at 9:59 PM, Bruce Momjian wrote: >>>>>> On Mon, Apr 15, 2013 at 12:52:54PM -0700, Josh Berkus wrote: >>>>>>> >>>>>>>> 2ndQuadrant has experienced significant delays in at least 3 cases >>>>>>>> also. There is definitely a problem somewhere there. >>>>>>> >>>>>>> The delay is called "volunteer moderators who have day jobs". >>>>>>> >>>>>>>> Perhaps we should make all posts wait the same length of time, to >>>>>>>> allow reasonable time to decide whether posts are suitable? 72 hours >>>>>>>> seems like a reasonable time for this. >>>>>>> >>>>>>> Who is going to do this strictly time-limited approving? >>>>>> >>>>>> So it auto-approves after 72 hours? I found this proposal vague. >>>>> >>>>> If anything automatic were to happen after 72 hours, the reasonable >>>>> thing would be a rejection. >>>> >>>> ... but that's not more helpful than not doing anything, because then >>>> the submitter needs to submit again. This creates a busy loop on which >>>> submitter needs to watch status of his submitted news until it gets >>>> approved. >>> >>> I agree. But it's the only thing we could do at all there. >>> >>> >>>> I think the idea behind 72-hour auto-approve is that if it's obvious >>>> spam someone will quickly reject it, and if it's not spam then it's not >>>> worth rejecting. I don't think this is very palatable either. >>> >>> Given thta our moderators *clearly* don't have time to process it, >>> this is almost *guarantee* to get spam postings onto our site. It >>> won't work. >>> >>> I think recruiting more moderators, or somehow convincing our current >>> ones to actually moderate more often is the only way to go. >> >> If helping to alleviate some of the delay issues would be to have more moderators, I would be happy to volunteer my time. > > We can certainly do with more moderators. Unless there are any > objections, I think adding Jonathan would be a good idea? +1 > > > >> Perhaps another initiative (though this is a tech suggestion) is to send a daily digest of news stories awaiting approval to the moderators so that way there is a constant reminder to review news items. > > This is something we already do, since many years back. yeah but the problem still is the same - most people do stuff in batches (ie on a quick train ride or in a break) so the same time they read the nagging mail the can just deal with the the real news item... Stefan -- Sent via pgsql-www mailing list (pgsql-www@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-www