Hi folks,
We are in the process of upgrading our Open Source Web Mapping Stack (ex.
MapServer, PostgreSQL, PostGIS, OpenLayers). However, we have run into an
issue with performance when switching from our manually compiled 9.6 PostgreSQL
version / PostGIS 2.4 to PostgreSQL 13 / PostGIS 3.x (yum install & config).
The rendering and map interaction is very slow. We are have tuned the database
based on our previous configuration and new documentation for PostgreSQL. Yet
performance is still suffering.
The database seems to be function as expected. We are tracking the requests
and responses from the database. Over 90% of the requests are being handled in
under 1 second. However, the one thing I did notice is the amount of queries
to obtain the postgis version. Why is this extra query/connection being sent?
Seems a bit too much.
Anyway, and help and/or suggestions would be greatly appreciated.
Linux - CentOS 7.x
MapServer - own server
PostgreSQL/PostGIS - own server
Application(s) - own server
Thanks
__:)
_ \<,_
(*)/ (*)
James Lugosi
Clackamas County GISP
IS Software Specialist, Senior
121 Library Court, Oregon City OR 97045
503-723-4829
_______________________________________________
MapServer-users mailing list
MapServer-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
