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. > -- > //www.freelists.org/webpage/oracle-l > > > -- > //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. > > -- > //www.freelists.org/webpage/oracle-l > > >