PostGIS vs. mySQL

[Rick Levine]

Hi Martin,

There is recent lengthy discussion of this in the PostgreSQL mailing
archives.

http://archives.postgresql.org/pgsql-general/2005-10/msg00262.php

You should look through this thread as there is tons of good info, though
mixed with lots of talk.

The main argument for PostgreSQL with PostGIS is that it scales to many
users at once better that MySQL, it is
SQL standard  compliant, and it maintains data integrity better.

But you need to tune it!  As installed out of the box it does not run well.
Please see the tuning threads
in the above archives for more info.

Cheers,

Rick

UMN MapServer Users List <MAPSERVER-USERS at LISTS.UMN.EDU> wrote on
10/20/2005 02:02:59 AM:

> I tried to use MapServer with a PostGIS database. The performance was not
> sufficient. After this I tried mySQL and this was much better. What are
the
> advantages and disadvantages of these database-systems ???