<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
There is a product called "EnterpriseDB" (<a class="moz-txt-link-abbreviated" href="http://www.enterprisedb.com">www.enterprisedb.com</a>) that is
marketed as a postgres-based drop-in replacement for Oracle. They were
all over LinuxWorld last year. Supposedly there's no porting
required. It's not free but they said it was some small fraction of
Oracle's cost (includes support of course).<br>
<br>
-Dave<br>
<br>
Brian Hurt wrote:
<blockquote cite="mid:Pine.LNX.4.64.0809271117350.2346@localhost"
type="cite">
<pre wrap="">
On Fri, 26 Sep 2008, Mike Miller wrote:
</pre>
<blockquote type="cite">
<pre wrap="">We have a lot of data -- apparently about 9,000 tables in an RDBMS. It's
in Oracle now. As a fan of open source solutions, I would prefer to use
MySQL or other open source RDBMS, but at what cost? Before I even
consider moving data to MySQL from Oracle, I want to know what Oracle can
do that MySQL (or other FOSS product) cannot do. Have any of you studied
this or do you know of any reasonably serious comparative research or
reviews? Thanks.
</pre>
</blockquote>
<pre wrap=""><!---->
We use Postgresql at work, and it works great. And it'd probably be
easier to move from Oracle to Postgres than from Oracle to MySql- of all
the open source databases, Postgres is the most like Oracle.
It also scales well. We don't have thousands of tables, but we do have
hundreds- several of which are at least medium-sized (pushing 100G per
table). And I know people who have 10's of TB in Postgres databases. It
also scales in terms of query complexity- we haven't noticed any problems
with queries until you start getting 60-100 tables in the same join.
So, in your situation, I'd recommend Postgresql rather strongly.
Brian
_______________________________________________
TCLUG Mailing List - Minneapolis/St. Paul, Minnesota
<a class="moz-txt-link-abbreviated" href="mailto:tclug-list@mn-linux.org">tclug-list@mn-linux.org</a>
<a class="moz-txt-link-freetext" href="http://mailman.mn-linux.org/mailman/listinfo/tclug-list">http://mailman.mn-linux.org/mailman/listinfo/tclug-list</a>
</pre>
</blockquote>
<br>
</body>
</html>