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 16EFB3A474C for ; Thu, 20 Jan 2005 13:03:59 +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 90978-09 for ; Thu, 20 Jan 2005 13:03:51 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.196]) by svr1.postgresql.org (Postfix) with ESMTP id 4993D3A2B8D for ; Thu, 20 Jan 2005 13:03:52 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id f1so4283rne for ; Thu, 20 Jan 2005 05:03:50 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:from:to:cc:subject:date:mime-version:content-type:x-mailer:in-reply-to:x-mimeole:thread-index:message-id; b=AsuGL+2cxZ7utLES4DA5BmVeMB8hjmQ3cgG6A8AqOcK6BAFGtfK0J60e1MJ9SHL4LMtW/yPpOynxXjJNv9IxlltMiDfSFIyXgp7zMLJAipZPeUJs04jzp3cMyyp3BDCDgBe3e4bUsDIx8OmXSvE2UTcPBtSasFlD+jy/65YMFFQ= Received: by 10.38.125.50 with SMTP id x50mr117196rnc; Thu, 20 Jan 2005 05:03:49 -0800 (PST) Received: from athena ([24.34.183.155]) by smtp.gmail.com with ESMTP id 71sm6157rnc.2005.01.20.05.03.49; Thu, 20 Jan 2005 05:03:49 -0800 (PST) From: "Troyston Campano" To: Cc: , Subject: Re: Oracle and Postgresql Play Nice Together on Same Computer? Date: Thu, 20 Jan 2005 08:03:42 -0500 Mime-Version: 1.0 Content-Type: text/plain; X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <28292295$110621206841ef74e4819f47.82018906@config19.schlund.de> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 thread-index: AcT+0YB1A75BQ+H6TLy3B4Nj+ZW6iQAHrV3Q Message-ID: <41efac35.405152b6.2a2f.00d1@smtp.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.033 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/215 X-Sequence-Number: 16074 Basically, we want to take 3 of the 10 applications running on Oracle, move them to Postgresql on the same computer/server and just make sure it runs about the same (really speed, memory usage, and space are the big issues). I'm not concerned with how hard the migration will be and things like that. The database is very low in complexity so the migration should be cake. Thank you! -----Original Message----- From: simon@2ndquadrant.com [mailto:simon@2ndquadrant.com] Sent: Thursday, January 20, 2005 4:20 AM To: Troyston Campano Cc: pgsql-admin@postgresql.org; pgsql-general@postgresql.org Subject: Re: [ADMIN] Oracle and Postgresql Play Nice Together on Same Computer? 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