Re: PostgreSQL 8.1 v. Oracle 10g xe

Chris Travers wrote:

> Recently I have been attempting to install Compiere. After spending a
> lot of time attempting to get it to work, I have given up installing
> it on PostgreSQL. I did however, get a little experience installing
> JDBC and PL/Java in the mean time.
>
> I discovered in the process of attempting to install Oracle 10g
> express edition that it is an extraordinary memory hog. One might
> have thought that one might have something that might have lower
> system requirements than the full version. However, this is not the
> case.
>
> The installation itself is about 2GB (meaning you need at least 2GB of
> free space and 352 MB RAM. The installation failed because it said I
> needed at least 700MB swap space to install on Linux based on these
> resources. Am I the only one who finds this disturbing? Why should
> an RDBMS require so much swap space?
>
> After this experience, I have a much more profound appreciation for
> the quality RDBMS that is PostgreSQL. PostgreSQL will install fine on
> any of my computers if I need it to.
>
> In short, thanks guys for such an awesome RDBMS. PostgreSQL will
> always remain my favorite.
>
> Best Wishes,
> Chris Travers
> Metatron Technology Consulting
>
>------------------------------------------------------------------------
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
I come from an Oracle 8.X/9.X on Windows background and to be honest we
are moving towards Postgres for as many applications/projects as we can.
We have to keep Oracle but now version Xe for the tougher to migrate
parts and I have been shocked at how Oracle Xe slows down a medium spec
pc/server. Oracle 8.x 9.x (Standard Edition) sure was slimmer!! And both
were a factor fatter than 7.X Seems like maybe all the bloat was
included and the features were just disabled. Roll on the happy day we
dispense with Oracle completely.

Many times a paid up Oracle support contract has been less help than
searching the Postgres mailing list archives. And the mailing lists are
probably as responsive to inquiry but with a more competent person
answering the Postgres question.

Oisin