Re: [MapServer-users] Why is Mapserver slower in Postgres 13 than in Postgres 11?

2024-02-06 Thread Seth G via MapServer-users
Hi Rob, Are you using the same MapServer machine to make the queries? If the MapServer version, and dependencies are all identical then the generated SQL queries should also be identical. You wrote about "hitting the web page" - but if the requested extents are different then it is likely the

Re: [MapServer-users] Why is Mapserver slower in Postgres 13 than in Postgres 11?

2024-02-06 Thread Rahkonen Jukka via MapServer-users
Hi, If spatial index is needed depends on the data. It is certainly needed when the table is large (million features or so) and requests typically cover a small area. If for example 1000 features gets selected it means that the spatial index can filter out 999 thousand features. If the table

Re: [MapServer-users] Why is Mapserver slower in Postgres 13 than in Postgres 11?

2024-02-06 Thread Rob Dennett via MapServer-users
Both DBs are hosted on AWS Aurora. The old one is serverless v1 and the new one is serverless v2. We were thinking that perhaps the geom column for my table needed a spatial index even though the old db doesn't have one. Is that possible? Also, would it make sense that the same query run on

Re: [MapServer-users] CGI variable "map" fails to validate

2024-02-06 Thread Rahkonen Jukka via MapServer-users
Hi, This one that is slightly edited from the MS4W config file works for me MS_MAP_PATTERN "^(C:)?\/ms4w_data\/((?!\.{2})[_A-Za-z0-9\-\.]+\/{1})*([_A-Za-z0-9\-\.]+\.(map))$" I am not a regexp expert but it seems like a slash must be escaped with a backslash. -Jukka Rahkonen- Lähettäjä:

Re: [MapServer-users] Why is Mapserver slower in Postgres 13 than in Postgres 11?

2024-02-06 Thread Rahkonen Jukka via MapServer-users
Hi, I made a test with a PostGIS on my own laptop. My versions are: "POSTGIS=""3.4.1 3.4.1"" [EXTENSION] PGSQL=""160"" GEOS=""3.12.1-CAPI-1.18.1"" SFCGAL=""SFCGAL 1.5.0, CGAL 5.6, BOOST 1.78.0"" PROJ=""8.2.1 The polygon layer has 215000 lake polygons. My BBOX select 73 polygons. It takes 66

[MapServer-users] CGI variable "map" fails to validate

2024-02-06 Thread Lernout, Matthew via MapServer-users
Hi, Having trouble making requests since updating to 8.0.1 from 7.6.2. Mapserver is running in IIS using FastCGI and the configuration steps from: https://mapserver.org/installation/iis.html A new config file was added to the filesystem and server Environment variables as per documented

Re: [MapServer-users] Why is Mapserver slower in Postgres 13 than in Postgres 11?

2024-02-06 Thread Rob Dennett via MapServer-users
So, I ran explain analyze, and got different results when run against the old and new db. I ran VACUUM on the table (which ran in less than ½ a second) and checked the query plans again. They're now the same except for the time estimates and against the new db they're still much slower. We

Re: [MapServer-users] Security and LDAP with mapservet

2024-02-06 Thread Bjørn Ove Grøtan via MapServer-users
G. Völkl via MapServer-users: > Hello, > > I want to create some WMS Services which can be only accessed by some Special > Users. > > Is it possible to Secure wms Services? Is it possible to use LDAP. > > Best regards Gerhard > Von meinem iPhone gesendet You can secure Mapserver WMS using

[MapServer-users] Security and LDAP with mapservet

2024-02-06 Thread G . Völkl via MapServer-users
Hello, I want to create some WMS Services which can be only accessed by some Special Users. Is it possible to Secure wms Services? Is it possible to use LDAP. Best regards Gerhard Von meinem iPhone gesendet ___ MapServer-users mailing list