Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 3A08D1337B5A for ; Thu, 11 Nov 2010 14:11:10 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 61306-10 for ; Thu, 11 Nov 2010 18:11:02 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lpo-relay-05.vmsinfo.com (lpo-relay-05.vmsinfo.com [216.169.137.116]) by mail.postgresql.org (Postfix) with ESMTP id B57741336971 for ; Thu, 11 Nov 2010 14:11:02 -0400 (AST) X-IronPort-AV: E=Sophos;i="4.59,184,1288584000"; d="scan'208";a="30081465" Received: from unknown (HELO lpo-mailbox-01.vmsinfo.com) ([216.169.137.252]) by lpo-relay-05.vmsinfo.com with ESMTP; 11 Nov 2010 13:11:02 -0500 Received: from [10.101.43.35] (unknown [216.169.135.235]) by lpo-mailbox-01.vmsinfo.com (Postfix) with ESMTP id 22D927D00B; Thu, 11 Nov 2010 13:11:02 -0500 (EST) Message-ID: <4CDC31B5.1060809@vmsinfo.com> Date: Thu, 11 Nov 2010 13:11:01 -0500 From: Mladen Gogala Organization: VMS User-Agent: Thunderbird 2.0.0.24 (X11/20101027) MIME-Version: 1.0 To: Tom Lane CC: Kevin Grittner , Robert Haas , "pgsql-performance@postgresql.org" Subject: Re: anti-join chosen even when slower than old plan References: <4CD9663502000025000374B1@gw.wicourts.gov> <20961.1289347680@sss.pgh.pa.us> <4CDA62C60200002500037512@gw.wicourts.gov> <4CDACBBF020000250003755B@gw.wicourts.gov> <4CDB7BAA.7020506@vmsinfo.com> <4CDBB0A40200002500037571@gw.wicourts.gov> <4CDC2424.9010102@vmsinfo.com> <17688.1289497551@sss.pgh.pa.us> In-Reply-To: <17688.1289497551@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/156 X-Sequence-Number: 41180 Tom Lane wrote: > More knobs and buttons is the Oracle way, True. Very true. > and the end result of that > process is that you have something as hard to use as Oracle. Also, you end up with something which is extremely reliable and adjustable to variety of conditions. > That's > generally not thought of as desirable in this community. > > regards, tom lane > Allow me to play the devil's advocate again. This community is still much, much smaller than even the MySQL community, much less Oracle's community. If growth of the community is the goal, copying a page or two from the Oracle's book, looks like a good idea to me. The only thing I dislike about Oracle is its price, not its complexity. -- Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 http://www.vmsinfo.com The Leader in Integrated Media Intelligence Solutions