RE: EnterpriseDB
- From: "Milen Kulev" <makulev@xxxxxxx>
- To: <rgoulet@xxxxxxxxxx>, <rjfeighery@xxxxxxxxx>, "'Oracle-L List'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Feb 2007 22:19:27 +0100
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Richard J. Goulet
Sent: Wednesday, February 21, 2007 3:55 PM
To: rjfeighery@xxxxxxxxx; 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@xxxxxxxxxx
: POWERING TRANSFORMATION
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
