Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1US6b5-0007F3-Oa for pgsql-www@arkaria.postgresql.org; Tue, 16 Apr 2013 14:10:59 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1US6b5-0005hN-88 for pgsql-www@arkaria.postgresql.org; Tue, 16 Apr 2013 14:10:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1US6b4-0005gf-Bg for pgsql-www@postgresql.org; Tue, 16 Apr 2013 14:10:58 +0000 Received: from mail-vc0-f171.google.com ([209.85.220.171]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1US6az-00042o-P2 for pgsql-www@postgresql.org; Tue, 16 Apr 2013 14:10:57 +0000 Received: by mail-vc0-f171.google.com with SMTP id ha12so419647vcb.30 for ; Tue, 16 Apr 2013 07:10:52 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=x-received:subject:mime-version:content-type:from:in-reply-to:date :cc:content-transfer-encoding:message-id:references:to:x-mailer :x-gm-message-state; bh=C6IItU0od519j5rhRvF4D3drJnGd80SunGw+dMze7Wg=; b=l+t2kj29fIuGvW/aCxPJeNIFtS/zKwNP73XeMVIGpvWxpM+ceV8DdR0qaVBi/rC+A6 UvQL+ch38DQU8ZTMX4ptRp3EdmmAEleyc6mNHT1uXd2eEZl8IeH6U8JS3tqaIt2zsVDk qTLycC54/+8ylKikApu+lkNkq0Pu6kSyV3OAKgMBkNEJTqiJA7BAuNW5CiRt3aHaeuf/ aRGJWtXSIH1bABN6dC1Zrc2CSDCEAGbDfHeFljo5su4X6N5gFLjccLzksNfEIcp4QgAD x8TRjz07XMSZEG6nQBTNrmR9x1/vkZGPbr9l+2Ur/AlzvkhUEmDME3Hkcor1vdIq/w2B GYQA== X-Received: by 10.220.116.5 with SMTP id k5mr1631801vcq.55.1366121452044; Tue, 16 Apr 2013 07:10:52 -0700 (PDT) Received: from ph33r-retina.home (pool-100-2-123-209.nycmny.fios.verizon.net. [100.2.123.209]) by mx.google.com with ESMTPS id yb6sm1511818veb.5.2013.04.16.07.10.49 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Tue, 16 Apr 2013 07:10:50 -0700 (PDT) Subject: Re: Stalled news about ora2pg 11 on pg.org Mime-Version: 1.0 (Apple Message framework v1280) Content-Type: text/plain; charset=iso-8859-1 From: "Jonathan S. Katz" In-Reply-To: Date: Tue, 16 Apr 2013 10:10:46 -0400 Cc: Alvaro Herrera , Bruce Momjian , Josh Berkus , PostgreSQL WWW Content-Transfer-Encoding: quoted-printable Message-Id: References: <516C4833.2050805@dalibo.info> <516C5A96.4020006@agliodbs.com> <20130415195918.GA4602@momjian.us> <20130415201046.GD8626@eldon.alvh.no-ip.org> To: Magnus Hagander X-Mailer: Apple Mail (2.1280) X-Gm-Message-State: ALoCoQm3o+dpHhxan9aI46a/Yl8IMkV1eAvAxZ/4jKVCEIH4e8N1K04DOaNMSyyEQD1qEXhAu1vq X-Pg-Spam-Score: -2.6 (--) 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 Apr 16, 2013, at 3: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: >>=20 >>> 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 wro= te: >>>>>> On Mon, Apr 15, 2013 at 12:52:54PM -0700, Josh Berkus wrote: >>>>>>>=20 >>>>>>>> 2ndQuadrant has experienced significant delays in at least 3 cases >>>>>>>> also. There is definitely a problem somewhere there. >>>>>>>=20 >>>>>>> The delay is called "volunteer moderators who have day jobs". >>>>>>>=20 >>>>>>>> Perhaps we should make all posts wait the same length of time, to >>>>>>>> allow reasonable time to decide whether posts are suitable? 72 hou= rs >>>>>>>> seems like a reasonable time for this. >>>>>>>=20 >>>>>>> Who is going to do this strictly time-limited approving? >>>>>>=20 >>>>>> So it auto-approves after 72 hours? I found this proposal vague. >>>>>=20 >>>>> If anything automatic were to happen after 72 hours, the reasonable >>>>> thing would be a rejection. >>>>=20 >>>> ... 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. >>>=20 >>> I agree. But it's the only thing we could do at all there. >>>=20 >>>=20 >>>> 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. >>>=20 >>> 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. >>>=20 >>> I think recruiting more moderators, or somehow convincing our current >>> ones to actually moderate more often is the only way to go. >>=20 >> If helping to alleviate some of the delay issues would be to have more m= oderators, I would be happy to volunteer my time. >=20 > We can certainly do with more moderators. Unless there are any > objections, I think adding Jonathan would be a good idea? >=20 >> 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. >=20 > This is something we already do, since many years back. Well, I think with that in place + a diligent moderation effort, that shoul= d prevent backlogs. Jonathan --=20 Sent via pgsql-www mailing list (pgsql-www@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-www