Hi James,
I've definitely been in your shoes before with these major Postgres
upgrades. Although not specific to your problem, here are some of my
first steps to verify in battling these types of issues:
- always set PROCESSING "CLOSE_CONNECTION=DEFER" on each PG layer
- always set EXTENT and "wms_extent" on each PG layer
- after the Postgres upgrade, execute on your restored database through
psql :
SELECT postgis_extensions_upgrade();
- possibly remove any need for a reprojection in your requests, and
re-test without
- set various CONFIG settings to turn on debugging (see
https://mapserver.org/optimization/debugging.html )
Those are some quick thoughts here, without any food in my stomach
before dinner, ha.
-jeff
--
Jeff McKenna
GatewayGeo: Developers of MS4W, MapServer Consulting and Training
co-founder of FOSS4G
http://gatewaygeo.com/
On 2022-01-24 3:39 p.m., Lugosi, Jim via MapServer-users wrote:
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
__J
_ \<,_
(_*_)/ (_*_)
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
