From: Alvaro Herrera <alvherre@dcc.uchile.cl>
To: Troyston Campano <troygeekdatabase@gmail.com>
Cc: simon@2ndquadrant.com
Cc: pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer?
Date: Thu, 20 Jan 2005 10:41:56 -0300
Message-ID: <20050120134156.GA16939@dcc.uchile.cl> (raw)
In-Reply-To: <41efac35.405152b6.2a2f.00d1@smtp.gmail.com>
References: <28292295$110621206841ef74e4819f47.82018906@config19.schlund.de>
<41efac35.405152b6.2a2f.00d1@smtp.gmail.com>
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[@]dcc.uchile.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: alvherre@dcc.uchile.cl, troygeekdatabase@gmail.com, simon@2ndquadrant.com, pgsql-general@postgresql.org
Subject: Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer?
In-Reply-To: <20050120134156.GA16939@dcc.uchile.cl>
References: <28292295$110621206841ef74e4819f47.82018906@config19.schlund.de> <41efac35.405152b6.2a2f.00d1@smtp.gmail.com> <20050120134156.GA16939@dcc.uchile.cl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox