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

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

From: "Troyston Campano" <troygeekdatabase(at)gmail(dot)com>
To: <simon(at)2ndquadrant(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Oracle and Postgresql Play Nice Together on Same Computer?
Date: 2005-01-20 13:03:42
Message-ID: 41efac35.405152b6.2a2f.00d1@smtp.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
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.
The database is very low in complexity so the migration should be cake.

Thank you!

-----Original Message-----
From: simon(at)2ndquadrant(dot)com [mailto:simon(at)2ndquadrant(dot)com] 
Sent: Thursday, January 20, 2005 4:20 AM
To: Troyston Campano
Cc: pgsql-admin(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)org
Subject: Re: [ADMIN] Oracle and Postgresql Play Nice Together on Same
Computer?


Troyston Campano <troygeekdatabase(at)gmail(dot)com> wrote on 20.01.2005,
06:03:28:
> I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the
> large corporation where I work to test the benefits of using Postgresql in
> our environment. I want to install Postgresql onto a "production" server
> that currently runs Oracle. Are there any problems with running Postgresql
> and Oracle on the same machine? I mean, I've heard that the way Sybase and
> DB2 UDB are architected to handle memory hurts Sybase when DB2 UDB is
> installed on the same machine as the Sybase Server (something about UDB
> eating up all the memory and not giving it back to Sybase).
> 
>  
> 
> Are there any issues running Postgresql and Oracle on the same
> machine.anything special to know about memory, disk layout, and things
like
> that? I just want to make sure the two engines play together on this same
> server. I had a hard time finding information about this via google.
> 

There should be no issues running both on the same machine. Running both
together at the same time isn't a good way of doing a benchmark
though...

I would question your intent slightly. Should it be a relative
comparison? Or should it be an assessment of what PostgreSQL is capable
of and whether that fits a sufficient number of your needs to make it
worth adopting?

There are many ways to structure a decision as to whether PostgreSQL is
suitable for your (business?) needs. Which structure you choose is
likely to prejudice your decision, one way or the other. i.e. if
capital acquisition costs are the decising factor, then PostgreSQL
would always win.

Best Regards, Simon Riggs


In response to

Responses

pgsql-admin by date

Next:From: Peter EisentrautDate: 2005-01-20 13:12:01
Subject: Re: Run external program on a trigger?
Previous:From: Troyston CampanoDate: 2005-01-20 12:58:04
Subject: Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer?

pgsql-general by date

Next:From: Tom LaneDate: 2005-01-20 13:14:08
Subject: Re: Unique Index
Previous:From: Troyston CampanoDate: 2005-01-20 12:58:04
Subject: Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer?

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