X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2B0DF329EEB for ; Fri, 15 Oct 2004 19:16:11 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16384-10 for ; Fri, 15 Oct 2004 18:16:03 +0000 (GMT) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.199]) by svr1.postgresql.org (Postfix) with ESMTP id 0B2C7329E7E for ; Fri, 15 Oct 2004 19:15:59 +0100 (BST) Received: by mproxy.gmail.com with SMTP id 73so6290rnk for ; Fri, 15 Oct 2004 11:15:57 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=o+W9CsWbxlsYzGJhpP8is7mB6XloZkGGB4zvKlb+ttVSS0dhwq8ktoZE1Eqkuyi+uX53Fz5+9LBTL1n4XGt5c8ktWbaZ+Eo8RG69nj5YVEUxjFpvZQOxTJxlP07FkbCAc1Gc4mT1ln0In8W4N8KCL0YJT4EJGewbpahpoT6F+FU Received: by 10.38.72.80 with SMTP id u80mr354382rna; Fri, 15 Oct 2004 11:15:25 -0700 (PDT) Received: by 10.38.208.68 with HTTP; Fri, 15 Oct 2004 11:15:25 -0700 (PDT) Message-ID: <9662496504101511152592fe4f@mail.gmail.com> Date: Fri, 15 Oct 2004 11:15:25 -0700 From: Marc Slemko Reply-To: Marc Slemko To: "richard_d_levine@raytheon.com" Subject: Re: Does PostgreSQL run with Oracle? Cc: pgsql-performance@postgresql.org In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=TO_ADDRESS_EQ_REAL X-Spam-Level: X-Archive-Number: 200410/228 X-Sequence-Number: 8704 On Fri, 15 Oct 2004 11:54:44 -0500, richard_d_levine@raytheon.com wrote: > My basic question to the community is "is PostgreSQL approximately as fast > as Oracle?" > > I don't want benchmarks, they're BS. I want a gut feel from this community > because I know many of you are in mixed shops that run both products, or > have had experience with both. That all depends on exactly what your application needs to do. There are many more features that Oracle has and postgres doesn't than vice versa. If you need to do something with your data that isn't possible to do as efficiently without one of those features, then yes postgresql can be much slower. If you don't need any such features, it can be ballpark, until you start getting into fairly hefty hardware.