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 4A0803A4110; Thu, 20 Jan 2005 13:42:20 +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 96517-05; Thu, 20 Jan 2005 13:42:13 +0000 (GMT) Received: from sunsite.dcc.uchile.cl (sunsite.dcc.uchile.cl [192.80.24.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4C0CE3A4779; Thu, 20 Jan 2005 13:42:06 +0000 (GMT) Received: from anakena.dcc.uchile.cl ([192.80.24.3]) by sunsite.dcc.uchile.cl (8.12.11/8.12.11) with ESMTP id j0KDfuvJ016072; Thu, 20 Jan 2005 10:41:56 -0300 (CLST) Received: by anakena.dcc.uchile.cl (Postfix, from userid 4151) id 396B0524AC; Thu, 20 Jan 2005 10:41:56 -0300 (CLST) Date: Thu, 20 Jan 2005 10:41:56 -0300 From: Alvaro Herrera To: Troyston Campano Cc: simon@2ndquadrant.com, pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer? Message-ID: <20050120134156.GA16939@dcc.uchile.cl> References: <28292295$110621206841ef74e4819f47.82018906@config19.schlund.de> <41efac35.405152b6.2a2f.00d1@smtp.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <41efac35.405152b6.2a2f.00d1@smtp.gmail.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.338 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200501/217 X-Sequence-Number: 16076 On Thu, Jan 20, 2005 at 08:03:42AM -0500, Troyston Campano wrote: > 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. So you want Postgres to be a cheaper Oracle. Hmm. Maybe it will work, but as Marco Colombo says, you are not going to see Postgres shining by using that simplistic approach. If you want that, maybe you should look closely to see where you can find the rusty corner that needs to be polished. > The database is very low in complexity so the migration should be cake. If you do things as simple as "select count(*) from table", then you will have to be careful to be really fair in your comparison; you could misleadingly find that Postgres is much slower on that query. -- Alvaro Herrera () Tulio: oh, para qué servirá este boton, Juan Carlos? Policarpo: No, aléjense, no toquen la consola! Juan Carlos: Lo apretaré una y otra vez.