Postgres or MySQL

Hi,

I wondered what you folks out there consider the best database for use
with RT. I have both Postgres and MySQL.

I know that Postgres is the relational database, which supports foreign
keys, subqueries, row locking and stuff, and that MySQL is just plain,
simple and fast - and not relational at all.

I really don’t care about referential integrity and trust RT to take
proper care of all database consistency - or am I being to trustful
here?

Has anyone ever compared both? Performance? Stability in relation to the
RT code (e.g. Oracle isn’t recommended for production environments at
this stage)? Consistency?

My test environment is running perfectly fine on MySQL, so unless
someone has a very strong argument in favour of Postgres, I’ll probably
just stick to MySQL, but I can still change now without any fuss.

Thanks,

Martin

Martin Schapendonk, martin@schapendonk.org, Phone: +31 (0)6 55770237
Student Information Systems and Management at Tilburg University