[mapserver-users] MapFile DATA CONNECTION

[Jeff McKenna]

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
> 
>