RE: EnterpriseDB

Hello Richard,
As already mentioned Postgres (and EnterpriseDB as itrs clone) can have more than One tablespace. The idea is to have separate mountpoints and to have appropriate RAID (10, 5) behind the mountpount that stripes the data among the disks.
Postgres storage manages relies (by design) heavily on the capabilities of the nderlying filesystems/volume manager. In PG each table is one file, BUT if the table becomes bigger than 2GB, the table will be splitted in many 2GB files. If you do not want this behaviour, you should recompile PG ;) PG really doesn't have a cluster. It has a sort of replication -slony -I, based on triggers ;( , And multimalster replication (pgcluster, loadbalancing). Both options are Open Source projects

HTH. Milen
P.S. Based on my experience I thing PG is better suitable for OLTP than for DHW. It is just my opinion, though...  

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Richard J. Goulet Sent: Wednesday, February 21, 2007 3:55 PM To: rjfeighery_at_gmail.com; Oracle-L List
Subject: RE: EnterpriseDB

YES, It's not a bad product, but there is a substantial amount of reading between the lines that you'll need doing. The underlying technology is PostGreSql which you can acquire for free from postgres.org. Migration is simple as they fully support functions and some procedures. I didn't see packages in PostGreSql so I believe EnterpriseDB's migration tool breaks them up into separate entities. Also PostGreSql's interpretation of tablespaces is different that ours. Where as in Oracle a database can have multiple tablespaces in postgresql they can have only one, but different databases can each have a separate tablespace or storage location. A lot better than MySql or Sql*Server, but not quite the same as Oracle. Also if your into clustering or replication your either stuck (no clustering yet in PostGreSql) or you have to use a third party tool which are also open sourced so not a really big deal. It works really great for decision support or trend analysis, or even a customer facing application like order status stuff. No it would not run an SAP or E-Business Suite like application very well and I would not want to store sensitive data therein either. But it is an attractive alternative to Oracle from a cost perspective. And acquiring it from EnterpriseDB vs. Postgresql.org does give you a phone number to call when the mess hits the fan.  

Dick Goulet, Senior Oracle DBA

45 Bartlett St Marlborough, Ma 01752, USA Tel.: 508.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795

RGoulet_at_kanbay.com

: POWERING TRANSFORMATION
-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ray Feighery Sent: Wednesday, February 21, 2007 12:46 AM To: Oracle-L List
Subject: EnterpriseDB

Has anyone used this?

http://www.enterprisedb.com/solutions/gotoracle.do

"EnterpriseDB offers an enterprise-class alternative to Oracle at a fraction of the cost. .... Making the switch from Oracle requires little or no modification to existing applications. Using our Migration Toolkit, the process is often completed in minutes. In fact, our clients report that more than 75% of their applications are 100% compatible, requiring NO changes to run on EnterpriseDB. ... Some EnterpriseDB clients choose to entirely replace Oracle; others use our databases as a more efficient alternative for specific applications and reports. ... EnterpriseDB Advanced Server is based on PostgreSQL"

Ray
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Feb 21 2007 - 15:19:27 CST