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 226BC32C0F7 for ; Fri, 15 Oct 2004 19:06:31 +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 14102-04 for ; Fri, 15 Oct 2004 18:06:20 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id ECA3732C0D5 for ; Fri, 15 Oct 2004 19:06:19 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i9FI6Iu9011591; Fri, 15 Oct 2004 14:06:18 -0400 (EDT) To: Richard_D_Levine@raytheon.com Cc: pgsql-performance@postgresql.org Subject: Re: Does PostgreSQL run with Oracle? In-reply-to: References: Comments: In-reply-to Richard_D_Levine@raytheon.com message dated "Fri, 15 Oct 2004 11:54:44 -0500" Date: Fri, 15 Oct 2004 14:06:18 -0400 Message-ID: <11590.1097863578@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/227 X-Sequence-Number: 8703 Richard_D_Levine@raytheon.com writes: > My basic question to the community is "is PostgreSQL approximately as fast > as Oracle?" The anecdotal evidence I've seen leaves me with the impression that when you first take an Oracle-based app and drop it into Postgres, it won't perform particularly well, but with tuning and tweaking you can roughly equal and often exceed the original performance. The two DBs are enough unalike that a database schema that's been tuned for Oracle is probably mistuned for Postgres. You will certainly find "some things are faster, some are slower" at the end of the day, but we've had lots of satisfied switchers ... regards, tom lane