Re: [GUSDEV] Postgres Vs. Oracle

[Michael S. <msa...@pc...>]

Hi Juan,

GUS *should* be stable and full featured in Postgres.  It is, of course much
younger code and thus there are likely to be more issues in Postgres than
Oracle.  As these issues come up, they're getting the same attention and
priority that Oracle bugs would get.

Out of the box, Postgres is much slower than Oracle, but you should be able
to optimize to eliminate much, if not all, of the difference.  I'm not sure
who has the largest pg GUS instance running (anyone?), but I can tell you
that GUS on Oracle has scaled for us easily past 500GB (although we've seen
some localized performance problems as we approach 700GB).

Oracle is, as you know, fairly expensive.  We have a site license and a DBA
(me) so for us it's the obvious choice.  Without one or both of these, and
knowing that your data will stay relatively small (under 2-3GB), Postgres is
probably a very good choice.

Ultimately, it comes down to performance needs v. costs and local
preferences.

Hope this helps some.

Mike



On 8/1/05 11:08 AM, "Juan Carlos Perin" <bi...@ge...> wrote:

> I apologize in advance if this topic has been discussed.  We are in the
> process of re-installing GUS and using RAD, but cannot decide on Postgres or
> Oracle.  We used Oracle for our previous installation, which we did on a
> learn as we go method...  We are starting from scratch, and have access to
> Oracle 9i if needed, although fear possibly being charged for it in the near
> future.
> 
> Our fist inclination is to go with Postgres to avoid costs in the future,
> but also because it is more familiar to us, and seems easier to work with in
> general.  Oracle is a bit more foreign to us, but seems like it probably has
> more use in the GUS community, and probably runs with more stability.  We're
> wondering whether Oracle really is more robust for 3.5?  Also, we plan on
> customizing a few components, so our initial assumption is that the oracle
> implementation is probably more familiar to the GUS community, so questions
> may be more easily approached with Oracle.
> 
> Really we're just looking for some reasons to go with one rather then the
> other;  whether Oracle is worth the price, when compared to the simplicity
> and cost efficiency of Postgres?  Thanks in advance!
> 
> Juan Perin
>   
> 
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev