X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6560A3A3D7D; Thu, 20 Jan 2005 09:22:18 +0000 (GMT) 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 59967-02; Thu, 20 Jan 2005 09:22:06 +0000 (GMT) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.177]) by svr1.postgresql.org (Postfix) with ESMTP id 9A7E63A4476; Thu, 20 Jan 2005 09:22:06 +0000 (GMT) Received: from [212.227.126.203] (helo=mrvnet.kundenserver.de) by moutng.kundenserver.de with esmtp (Exim 3.35 #1) id 1CrYVu-0003OH-00; Thu, 20 Jan 2005 10:22:02 +0100 Received: from [172.23.4.146] (helo=config19.kundenserver.de) by mrvnet.kundenserver.de with esmtp (Exim 3.35 #1) id 1CrYVu-00006X-00; Thu, 20 Jan 2005 10:22:02 +0100 Received: from www-data by config19.kundenserver.de with local (Exim 3.35 #1 (Debian)) id 1CrYVu-0003Mg-00; Thu, 20 Jan 2005 10:22:02 +0100 To: =?iso-8859-1?Q?Troyston_Campano?= Subject: =?iso-8859-1?Q?Re:__Oracle_and_Postgresql_Play_Nice_Together_on_Same_Computer??= From: Cc: , Message-Id: <28292295$110621206841ef74e4819f47.82018906@config19.schlund.de> X-Binford: 6100 (more power) X-Originating-From: 28292295 X-Mailer: Webmail X-Routing: UK X-Received: from config19 by 193.114.111.34 with HTTP id 28292295 for troygeekdatabase@gmail.com; Thu, 20 Jan 2005 10:20:02 +0100 Content-Type: text/plain; charset="iso-8859-1" Mime-Version: 1.0 Content-Transfer-Encoding: 8bit X-Priority: 3 Date: Thu, 20 Jan 2005 10:20:02 +0100 X-Provags-ID: kundenserver.de abuse@kundenserver.de ident:@172.23.4.146 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.425 tagged_above=0 required=5 tests=AWL, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200501/211 X-Sequence-Number: 16070 Troyston Campano wrote on 20.01.2005, 06:03:28: > I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the > large corporation where I work to test the benefits of using Postgresql in > our environment. I want to install Postgresql onto a "production" server > that currently runs Oracle. Are there any problems with running Postgresql > and Oracle on the same machine? I mean, I've heard that the way Sybase and > DB2 UDB are architected to handle memory hurts Sybase when DB2 UDB is > installed on the same machine as the Sybase Server (something about UDB > eating up all the memory and not giving it back to Sybase). > > > > Are there any issues running Postgresql and Oracle on the same > machine.anything special to know about memory, disk layout, and things like > that? I just want to make sure the two engines play together on this same > server. I had a hard time finding information about this via google. > There should be no issues running both on the same machine. Running both together at the same time isn't a good way of doing a benchmark though... I would question your intent slightly. Should it be a relative comparison? Or should it be an assessment of what PostgreSQL is capable of and whether that fits a sufficient number of your needs to make it worth adopting? There are many ways to structure a decision as to whether PostgreSQL is suitable for your (business?) needs. Which structure you choose is likely to prejudice your decision, one way or the other. i.e. if capital acquisition costs are the decising factor, then PostgreSQL would always win. Best Regards, Simon Riggs