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 <[email protected]> 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 ???
