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 AC05132BEE1 for ; Fri, 15 Oct 2004 17:57:36 +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 91708-09 for ; Fri, 15 Oct 2004 16:57:28 +0000 (GMT) Received: from lax-gate3.raytheon.com (lax-gate3.raytheon.com [199.46.200.232]) by svr1.postgresql.org (Postfix) with ESMTP id 6219D32BEDB for ; Fri, 15 Oct 2004 17:57:22 +0100 (BST) Received: from ds02w00.directory.ray.com (ds02w00.directory.ray.com [147.25.146.118]) by lax-gate3.raytheon.com (8.12.10/8.12.10) with ESMTP id i9FGupdw003025 for ; Fri, 15 Oct 2004 09:56:56 -0700 (PDT) Received: from ds02w00 (localhost [127.0.0.1]) by ds02w00.directory.ray.com (Switch-3.1.4/Switch-3.1.0) with ESMTP id i9FGuekD027050 for ; Fri, 15 Oct 2004 16:56:44 GMT Received: from ds02w00.directory.ray.com with LMTP by ds02w00 (2.0.6/sieved-2-0-build-559) for ; Fri, 15 Oct 2004 16:56:40 +0000 Received: from notesserver5.ftw.us.ray.com (notesserver5.ftw.us.ray.com [151.168.145.35]) by ds02w00.directory.ray.com (Switch-3.1.4/Switch-3.1.0) with ESMTP id i9FGsolF026508 sender Richard_D_Levine@raytheon.com for ; Fri, 15 Oct 2004 16:54:51 GMT Subject: Does PostgreSQL run with Oracle? To: X-Mailer: Lotus Notes Release 5.0.8 June 18, 2001 Message-ID: From: Richard_D_Levine@raytheon.com Date: Fri, 15 Oct 2004 11:54:44 -0500 X-MIMETrack: Serialize by Router on NotesServer5/HDC(Release 5.0.13a |April 8, 2004) at 10/15/2004 11:54:51 AM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-SPAM: 0.00 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200410/220 X-Sequence-Number: 8696 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. I fully intend to tune, vacuum, analyze, size buffers, etc. I've read what people have written on the topic, and from that my gut feel is that using PostgreSQL will not adversely affect performance of my application versus Oracle. I know it won't adversely affect my pocket book. I also know that requests for help will be quick, clear, and multifaceted. I'm currently running single processor UltraSPARC workstations, and intend to use Intel Arch laptops and Linux. The application is a big turnkey workstation app. I know the hardware switch alone will enhance performance, and may do so to the point where even a slower database will still be adequate. Whadyall think? Thanks, Rick