<div dir="ltr"><div dir="ltr"><span class="gmail-ui-provider ed gmail-buz gmail-bsu gmail-bva gmail-bvb gmail-bvc gmail-bvd gmail-bve gmail-bvf gmail-bvg gmail-bvh gmail-bvi gmail-bvj gmail-bvk gmail-bvl gmail-bvm gmail-bvn gmail-bvo gmail-bvp gmail-bvq gmail-bvr gmail-bvs gmail-bvt gmail-bvu gmail-bvv gmail-bvw gmail-bvx gmail-bvy gmail-bvz gmail-bwa gmail-bwb gmail-bwc gmail-bwd gmail-bwe gmail-bwf" dir="ltr"><p>product_assurance=# SELECT version(), postgis_full_version();<br>
version | postgis_full_version</p><p> </p><p>----------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------<br>
--------------------------------------------------------------------------<br>
PostgreSQL 13.14 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit | POSTGIS="3.1.10 4e93a1a" [EXTENSION] PGSQL="130" GEOS="3.12.1-CAPI-1.18.1" SFCGAL="1.4.1" PROJ="9.2.1" LIB<br>
XML="2.9.7" LIBJSON="0.13.1" LIBPROTOBUF="1.3.0" WAGYU="0.5.0 (Internal)"<br></p></span><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, 22 Feb 2024 at 14:38, Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg7678184717212239745"><div lang="EN-US" style="overflow-wrap: break-word;"><div class="m_7678184717212239745WordSection1"><p class="MsoNormal">Possible or one of the dependencies is different, or planner differences such as the CTE changes that came in PostgreSQL 12, but hard to tell given the information you have provided<u></u><u></u></p><p class="MsoNormal">Or you didn’t reindex your data after the upgrade to a newer version of PostgreSQL and such a reindex was required.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">I have had to change some of my CTEs queries after upgrading to PostgreSQL 12+ to get back to same speed or better as prior runs for example.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">First of all?<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">What does the below return now (and if you can remember the key bits like GEOS, PROJ, PostgreSQL Version what did you have before)<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">SELECT version(), postgis_full_version();<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Two, If you can provide the query you are trying to run, that would help, as we may see a pattern there.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><u></u> <u></u></p><div style="border-top:none;border-right:none;border-bottom:none;border-left:1.5pt solid blue;padding:0in 0in 0in 4pt"><div><div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in"><p class="MsoNormal"><b>From:</b> Shaozhong SHI <<a href="mailto:shishaozhong@gmail.com" target="_blank">shishaozhong@gmail.com</a>> <br><b>Sent:</b> Thursday, February 22, 2024 9:23 AM<br><b>To:</b> PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br><b>Subject:</b> PostGIS performance issue<u></u><u></u></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal"><span style="font-size:12pt;color:black">My system has recently been upgraded from Linux 7 to Linux 8.<br><br>There are performance issues with PostGIS <br><br>"A process used to take 3.9 hours. Now, it has taken more than 2 days and yet it has not completed running. No errors have been flagged up."</span><u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><span style="font-size:12pt;color:black">Is possible the PostGIS not configured properly?</span><u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><span style="font-size:12pt;color:black">Regards,</span><u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal" style="margin-bottom:12pt"><span style="font-size:12pt;color:black">David</span><u></u><u></u></p></div></div></div></div></div></div></blockquote></div>