Using PostgreSQL as UML repository

[ufechner]

Hello,

we bought a couple of EA licences and want to migrate to an SQL server.

Our admin suggested using PostgreSQL instead of mysql.

Does EA work well with a PostgreSQL 8.2.4 database server?

Regards:

Uwe Fechner

[«Midnight»]

Probably Uwe,

See http://www.sparxsystems.com.au/resources/corporate/postgresql_instructions.html for minumum versions for PostgreSQL and the ODBC driver.

David

[Aaron B]

Performance-wise we have typically seen better results from MySQL than from PostgreSQL.  Feel free to try for yourself, but if you have the option, MySQL would be the more highly recommended of the two DBMS's.

[ufechner]

Performance-wise we have typically seen better results from MySQL than from PostgreSQL.

When using ISAM or InnoDB tables?

PostgreSQL often does need a little bit of tweaking of the configuration settings, to achieve a good performance.
My experience is, that MySQL is a little bit more performant with very simple queries, but PostgreSQL is much more performant, if you use complicated queries with many tables and relations.

And PostgreSQL uses an additional object ID field by default. You can switch it off, if you don't need it (this brings a little bit better performance).

Regards:

Uwe Fechner

[sargasso]

Uwe,

I've had no problems with 8.2.4 running on all of a Win server and linux servers (FC5 2.6.15 kernel and MDV 2.6.17 kernel).   As you say, postgresql is very tweakable but I've not had to do anything.  The models are "large" but the users are "few".

bruce