Re: Oracle out the door

postgresql has some things which are rather different from oracle (for
example intensive usage of the o/s cache).
also the lack of instrumentation (when compared with oracle) is frustrating.

btw, another shameless plug: I've made a rewrite of the statspack for
postgresql, anyone interested?

frits


On Wed, Apr 30, 2008 at 3:08 PM, Goulet, Dick <richard.goulet@xxxxxxxxxxxxx>
wrote:

> Derek,
>
>        Shameless plug indeed, but good product as I have tried using it
> in the past.  The problem is that it comes with a license cost which in
> some shops is the "blue screen of death" since it can be downloaded &
> used directly from postgresql.org.  And even though EnterpriseDB has
> done a very good job of porting Oracle functionality into PostgreSql,
> it's not 100% transparent which means some re-engineering nonetheless.
>
>        BTW: When I was using PostGreSql I had two real problems with it
> that I believe have been fixed & maybe you can comment on the fixes.
> The first was the need to "vacuum" the db regularly so that the
> equivalent of the Oracle SCN would not wrap onto itself.  The second was
> that all of the db files had to be on a single mount point so that your
> database was limited to the size of a mount and if you ever got it to
> 100% used the db would crash, badly.
>
> ______________________________________________________________
> Dick Goulet / Capgemini
> North America P&C / East Business Unit
> Senior Oracle DBA / Hosting
> Office: 508.573.1978 / Mobile: 508.742.5795 / www.capgemini.com
> Fax: 508.229.2019 /  Email: richard.goulet@xxxxxxxxxxxxx
> 45 Bartlett St. / Marlborough, MA 01752
>
> Together: the Collaborative Business Experience
> ______________________________________________________________
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Derek Rodner
> Sent: Tuesday, April 29, 2008 6:10 PM
> To: gints.plivna@xxxxxxxxx; jhthomp@xxxxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx
> Subject: RE: Oracle out the door
>
> Sorry, but I am going to put a shameless plug in here.  Has your company
> looked at EnterpriseDB?  It is based on Postgres, but we added a ton of
> Oracle features including PL/SQL syntax support, Oracle Packages, system
> views, stored procedures, etc, etc, etc.
>
> Ok, shameless plug over.
>
> Derek M. Rodner
> Director, Marketing
> EnterpriseDB Corporation
> 732.331.1333 office
> 484.252.1943 cell
> www.enterprisedb.com
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Gints Plivna
> Sent: Tuesday, April 29, 2008 5:48 PM
> To: jhthomp@xxxxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx
> Subject: Re: Oracle out the door
>
> Following ideas comes to mind:
> 1) Have you/your company considered other editions than EE? I.e. SE,
> SE One, trying to get discounts, optimizing (e.g. throwing several
> apps on the same boxes) environments?
> 2) Have you/your company calculated all other costs connected with
> database change i.e. staff skills, possibility to rebuild applications
> totally from scratch, possibility to have various kind of problems
> because of lack of knowledge and migration to other DBMSes? A while
> ago I've summarized a few criteria for choosing DBMS and the main
> message I'd like to offer is - as probably everyone knows - the cost
> of DB is not the same as the cost of DBMS licence.
> In case anyone is interested the article is here
> http://gplivna.eu/papers/choose_database.htm
>
> Gints Plivna
> http://www.gplivna.eu
>
>
> 2008/4/29 John Thompson <jhthomp@xxxxxxxxx>:
> > Company I work for just announced that we're going to convert all but
> 2 of
> > our 89 Oracle databases to either SQL Server, MYSQL,  or PostgreSQL.
> This
> > is due to the high licensing cost.  I'm bummed.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
>
>
>
>
> This message contains information that may be privileged or confidential
> and is the property of the Capgemini Group. It is
> intended only for the person to whom it is addressed. If you are not the
> intended recipient, you are not authorized to
> read, print, retain, copy, disseminate, distribute, or use this message or
> any part thereof. If you receive this message
> in error, please notify the sender immediately and delete all copies of
> this message.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: