How well is it instrumented? Not nearly as well as Oracle, but for some reason I never had a real problem with SQL execution since PG uses a cost based optimizer exclusively. 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 ________________________________ From: Stefan Knecht [mailto:knecht.stefan@xxxxxxxxx] Sent: Thursday, February 22, 2007 1:31 AM To: Richard J. Goulet Cc: oracle-l Subject: Re: EnterpriseDB But how well are those open source databases instrumented ? How deep under the hood can you look when stuff doesn't run as fast as you'd like it to (other than reading the source code to try and figure out what's going on) ? For me that is one of the most important features of an rdbms database - and Oracle's instrumentation kicks butt :) Stefan On 2/21/07, Richard J. Goulet <rgoulet@xxxxxxxxxx> wrote: Open Ingres for sure, and Firebird. 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 ________________________________ From: Milen Kulev [mailto:makulev@xxxxxxx] Sent: Wednesday, February 21, 2007 4:29 PM To: Richard J. Goulet Cc: 'Oracle-L List' Subject: RE: EnterpriseDB Dick, apart from MySQL and PG , what are the other (serious) offerings ? In my opinion thereare not so many ... Regrads. Milen -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto: oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx> ] On Behalf Of Richard J. Goulet Sent: Wednesday, February 21, 2007 6:17 PM To: Mark Strickland; ineyman@xxxxxxxxxxxxxx Cc: rjfeighery@xxxxxxxxx; Oracle-L List Subject: RE: EnterpriseDB Agree, I was asked to "pick my own poison" from the open source world a few years ago, before EnterpriseDB exited. If you are going to use an open source db I'd highly recommend PostGreSql over ALL of the other offerings out there, particularly MySql. 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 ________________________________ From: Mark Strickland [mailto:strickland.mark@xxxxxxxxx] Sent: Wednesday, February 21, 2007 11:30 AM To: ineyman@xxxxxxxxxxxxxx Cc: Richard J. Goulet; rjfeighery@xxxxxxxxx; Oracle-L List Subject: Re: EnterpriseDB We use Postgres for a small application and I evaluated EnterpriseDB earlier this year for its replication functionality so that we could replicate transactions from the primary Production database server to a failover server. I did a basic functional test, not a smoke test. I was able to install it and set up the replication without much heartache. Their technical support was quite good especially compared to a similar company's product that we evaluated. Mark Strickland Seattle, WA