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

[Seth G]

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 client requests are different. Are you using WMS services? What do these requests look like?
Also you mention 4 different layers, so I'd try testing them one by one - are they all generating different SQL and response times?

Seth

--
web:https://geographika.net & https://mapserverstudio.net
twitter: @geographika

On Tue, Feb 6, 2024, at 8:53 PM, Rob Dennett via MapServer-users wrote:
> 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 both should take the same amount of time (roughly)?
> 
> Thanks,
> Rob
> 
> 
> 
> 
> _______________________________________________
> MapServer-users mailing list
> MapServer-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20240206/af3bcd09/attachment.htm>