X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 02F5E3A46CF for ; Thu, 20 Jan 2005 14:22:48 +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 06278-06 for ; Thu, 20 Jan 2005 14:22:41 +0000 (GMT) Received: from Nazgul.esiway.net (Nazgul.ESIWAY.NET [193.194.16.154]) by svr1.postgresql.org (Postfix) with ESMTP id 7CD883A18CF for ; Thu, 20 Jan 2005 14:22:42 +0000 (GMT) Received: from Megathlon.ESI (Ghost.esi.it [193.194.16.225]) by Nazgul.esiway.net (8.13.1/8.13.1) with ESMTP id j0KEMO8f007941 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=FAIL); Thu, 20 Jan 2005 15:22:24 +0100 Received: from relay.ESI (relay.ESI [10.10.10.3]) (user=marco mech=CRAM-MD5 bits=0) by Megathlon.ESI (8.12.11/8.12.11) with ESMTP id j0KEMXg8026636 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 20 Jan 2005 15:22:33 +0100 Date: Thu, 20 Jan 2005 15:22:33 +0100 (CET) From: Marco Colombo X-X-Sender: marco@Megathlon.ESI To: Alvaro Herrera Cc: pgsql-general@postgresql.org Subject: Re: [ADMIN] Oracle and Postgresql Play Nice Together on Same Computer? In-Reply-To: <20050120134156.GA16939@dcc.uchile.cl> Message-ID: References: <28292295$110621206841ef74e4819f47.82018906@config19.schlund.de> <41efac35.405152b6.2a2f.00d1@smtp.gmail.com> <20050120134156.GA16939@dcc.uchile.cl> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/1080 X-Sequence-Number: 72029 [ Cc: list cleaned a bit ] On Thu, 20 Jan 2005, Alvaro Herrera wrote: > 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. Yeah, that's precisely what I meant. The Oracle to PostgreSQL migration is well worth considering a (partial) redesign. Sometimes I happen to show some SQL queries I make (on PostgreSQL) to an Oracle guy. Usually it goes like this: 1) hmm (ponders at the query) 2) ah!!! (realizes what the query does) 3) I didn't know you could do this! (excitement) 4) hmm (ponders again if that may work on Oracle as well) 5) no I can't do that in Oracle that way. I remember I did something like that in the past with other 3 SQL developers. We had to write a 300 lines long stored procedure, we got the locking right at the third reimplementation only (we don't know if we do need the locking, we asked our senior DBA but he was unsure as well, so we put it in, we don't think it hurts anyway). Ok, point 5) has been exaggerated to joke level, but you get the idea. .TM. -- ____/ ____/ / / / / Marco Colombo ___/ ___ / / Technical Manager / / / ESI s.r.l. _____/ _____/ _/ Colombo@ESI.it