On Thu, Jan 20, 2022 at 4:50 PM Lugosi, Jim <jim...@clackamas.us> wrote:
>
> Hi folks,
>
>
>
> We are struggling to figure out what is going on. We are migrating from 
> PostgreSQL 9.6 to PostgreSQL 13 w/ PostGIS. Our 9.6 version was compiled from 
> source and the new version (13) was installed using Yum. BTW, the new version 
> is on a VM that has 16GB of memory, two cores, and 500 GB of disk. In 
> addition, we are using MapServer as our mapping engine and OpenLayers as the 
> client side interface. Once we switch over to the new version of PostgreSQL, 
> the performance takes a big nose dive. We have being tweaking and tuning the 
> database and it appears to be happy but the response times from mapfile 
> requests are 3 -7 seconds. Previously, the response time was below a second.

please post EXPLAIN ANALYZE for a query that you think is
underperforming.  Ideally, we can also produce from legacy 9.6
equivalent.

merlin


Reply via email to