Forum OpenACS Q&A: Re: Postgres vs. Oracle for OpenACS

Posted by Bruno Mattarollo on
Hello Jade,

Well, the answer to that question really depends on the functionality that you really need for that intranet. For example, we at Greenpeace, decided to go Oracle because of interMedia, despites the nightmare that it might be, it still provided us (two years ago, when the decision was made) with full text search within the DB in multiple languages and some other features that we don't really use... Some others (features) we do use, as mentionned, interMedia, online-backups, integrates nicely with the backup services at our provider, knowlege in-house and at the provider, etc ...

Our mid-term to long-term was to slowly migrate to PG when some of the most critical functionality would start to be available. Still not the moment but if you are migrating, asking some of these questions might help :)

Just my 2 cents.

Posted by Jeff Davis on
I would probably go with postgres if your database is not too large (and to me too large is probably something like 5gb), didn't need replication or other high availability features of oracle, and could get along without the permissioning, table partitioning, and other fancy oraclisms (all of which are not really used by acs/openacs anyway, unless you have added them).

That said, I know people at redhat are deploying postgres as HA solutions (though not with replication as far as I know) and postgres seems to be gaining ground quickly.

I have been really beating on postgres to see what breaks and it has held up really well. I have been writing up the stuff I did specifically on forums tuning if you are interested.