<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hi folks,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Anyway, and help and/or suggestions would be greatly appreciated.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Linux – CentOS 7.x<o:p></o:p></p>
<p class="MsoNormal">MapServer – own server<o:p></o:p></p>
<p class="MsoNormal">PostgreSQL/PostGIS – own server<o:p></o:p></p>
<p class="MsoNormal">Application(s) – own server<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:6.0pt"><span style="font-size:10.0pt;font-family:"Courier New""> __</span><span style="font-size:7.5pt;font-family:Wingdings;color:#333399">J</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif"><br>
</span><span style="font-size:10.0pt;font-family:"Courier New""> _ \<,_</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif"><br>
</span><span style="font-size:10.0pt;font-family:"Courier New""> (<u>*</u>)/ (<u>*</u>)</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif">
<o:p></o:p></span></p>
<p class="MsoNormal">James Lugosi<o:p></o:p></p>
<p class="MsoNormal">Clackamas County GISP<o:p></o:p></p>
<p class="MsoNormal">IS Software Specialist, Senior<o:p></o:p></p>
<p class="MsoNormal">121 Library Court, Oregon City OR 97045<o:p></o:p></p>
<p class="MsoNormal">503-723-4829<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>