Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer?

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Troyston Campano <troygeekdatabase(at)gmail(dot)com>
Cc: simon(at)2ndquadrant(dot)com, pgsql-admin(at)postgresql(dot)org,pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer?
Date: 2005-01-20 13:41:56
Message-ID: 20050120134156.GA16939@dcc.uchile.cl (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
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 (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
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.

In response to

Responses

pgsql-admin by date

Next:From: Marco ColomboDate: 2005-01-20 14:22:33
Subject: Re: [ADMIN] Oracle and Postgresql Play Nice Together on Same Computer?
Previous:From: Peter EisentrautDate: 2005-01-20 13:12:01
Subject: Re: Run external program on a trigger?

pgsql-general by date

Next:From: VittorioDate: 2005-01-20 13:47:34
Subject: Re: Best Linux Distribution
Previous:From: Bruno LavoieDate: 2005-01-20 13:38:56
Subject: Re: Debian Sarge, Postgres 7.4.6 + PAM

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group