[mapserver-users] MapFile DATA CONNECTION

[Lugosi, Jim]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20220124/c2fd4f8a/attachment.html>