big d

I'm just about to try building a version of our OLAP database with
mondrian. As a back end, I'll either use postgresql or mysql. I have a
lot of experience with postgres and will probably use it, but I wanted to
hear from others if there was any significant advantage of mysql over
postgres when used in this role.

Thanks!

nvs

Hi, Mysql is better for small datamarts and works fine with
mondrian.But its performance degrades if the fact table more than half
a milion rows.with mysql 4 the picture might be better but there are
liencing issues(So i didnt use that) and limitations of mysql 3.2 might
make you crazy during ETL.
With postgres stored procedures,views will be useful and will be better
for large databases.For performance you can use indexing .You can also
hack mondrian to use materialzed views on postgresql generated with
triggers.If that works then nothing like it.