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 6336D3A486B; Thu, 20 Jan 2005 16:39:34 +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 25515-09; Thu, 20 Jan 2005 16:39:30 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 5307C3A48A8; Thu, 20 Jan 2005 16:39:29 +0000 (GMT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 20 Jan 2005 10:39:29 -0600 Subject: Re: [GENERAL] Oracle and Postgresql Play Nice Together on From: Scott Marlowe To: Troyston Campano Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org, 'Ian Barwick' In-Reply-To: <41efaae3.39b41852.390e.00a8@smtp.gmail.com> References: <41efaae3.39b41852.390e.00a8@smtp.gmail.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1106239169.16640.18.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 20 Jan 2005 10:39:29 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/220 X-Sequence-Number: 16079 On Thu, 2005-01-20 at 06:58, Troyston Campano wrote: > I guess what I am concerned about *is* running on a production server more > than a test server. Basically, I'd be taking a couple applications that are > running on the Oracle database instance, building a Postgresql instance, and > migrating them to that postgresql database instance. I'm just wondering > whether it's a bad idea to run them on the same server machine in a > production environment. (So instead of having 10 applications running on > Oracle on ServerComputerA...build a new postgresql instance on > ServerComputerA that lives along with Oracle and migrating 3 of the > applications to Postgresql. Have you got a spare machine you can do the testing on at first? That will allow you to throw big nasty queries at the server and tune it first, before putting postgresql on the production box. I'd recommend reading the tuning document from varlena: http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html And experimenting with various settings on a test box first. My first PostgreSQL server way back when was running 6.5.2 or so on my P-II-300 workstation with 128 Megs of ram sitting under my desk, and it ran quite well, well enough we used it as our development / staging server for almost a year.