Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 6D5879FBB64 for ; Tue, 19 Jun 2007 00:01:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 13662-02 for ; Tue, 19 Jun 2007 00:01:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.231]) by postgresql.org (Postfix) with ESMTP id 97F279FB677 for ; Tue, 19 Jun 2007 00:01:31 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id m22so1369783nzf for ; Mon, 18 Jun 2007 20:01:30 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:subject:references:in-reply-to:x-enigmail-version:content-type:content-transfer-encoding; b=cU76J0zqP5CoeuFHcZHBWpyyA5wARgf2xiVYJ6w0ROj0IANcPaVhhXk3DnNczWttSN7SXi5Ovw1RlSzJc8tqj7r4TsFjOruUJTUXYRCDsm+WC/51Or6ehRGTKFIorekApMazxWRmoQXGyhhqoKQvjDOHVGfPy2XilY4rzcBx/n4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:subject:references:in-reply-to:x-enigmail-version:content-type:content-transfer-encoding; b=qXdRPZM94b9W34LV3ZTiRjSXCv6ti2R6rFmvO4B9rU1cLKhDMFmZRGbYWSe42ljGgQrFmAmdGZEjVhlRy+bsDteznvFLRM0I+R7X9ojvsJu/4jwN35BPyTC+WfvshqrD3bbFF77ZBuCJvsdrtoU4JkSISe8HGd6FA/seN1LFhv0= Received: by 10.115.89.1 with SMTP id r1mr6912549wal.1182222090549; Mon, 18 Jun 2007 20:01:30 -0700 (PDT) Received: from ?192.168.0.102? ( [67.164.252.164]) by mx.google.com with ESMTP id k26sm16069107waf.2007.06.18.20.01.27 (version=TLSv1/SSLv3 cipher=RC4-MD5); Mon, 18 Jun 2007 20:01:28 -0700 (PDT) Message-ID: <4677472F.9020806@gmail.com> Date: Mon, 18 Jun 2007 21:02:07 -0600 From: John Meyer User-Agent: Thunderbird 2.0.0.0 (X11/20070418) MIME-Version: 1.0 To: pgsql-advocacy@postgresql.org Subject: Re: [GENERAL] [PERFORM] [ADMIN] Postgres VS Oracle References: <36e682920706180910y519bc6a5h11e0ba56f45009ec@mail.gmail.com> <4676B7C7.6020801@kostyrka.org> <36e682920706181002i495f3fc3s2d55472e36a91b63@mail.gmail.com> <4676BE31.6040701@commandprompt.com> In-Reply-To: X-Enigmail-Version: 0.95.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/202 X-Sequence-Number: 11251 PFC wrote: > >> 2. Oracle, Microsoft, and IBM have a "lot" to fear in the sense of a >> database like PostgreSQL. We can compete in 90-95% of cases where >> people would traditionally purchase a proprietary system for many, >> many thousands (if not hundreds of thousands) of dollars. > > Oracle also fears benchmarks made by people who don't know how to > tune Oracle properly... > > ---------------------------(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 > Then Oracle fears its users, which explains the "no-benchmark" policy, which I cannot see any PR honk being able to spin that in any way that doesn't make Oracle look like it's hiding its head in the sand. -- The NCP Revue -- http://www.ncprevue.com/blog