[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: RE: PostGIS performance issue
From: "Regina Obe" <lr () pcorp ! us>
Date: 2024-02-22 14:38:35
Message-ID: 002501da659c$d1b36730$751a3590$ () pcorp ! us
[Download RAW message or body]
This is a multipart message in MIME format.
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
Or you didn't reindex your data after the upgrade to a newer version of PostgreSQL \
and such a reindex was required.
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.
First of all?
What does the below return now (and if you can remember the key bits like GEOS, PROJ, \
PostgreSQL Version what did you have before)
SELECT version(), postgis_full_version();
Two, If you can provide the query you are trying to run, that would help, as we may \
see a pattern there.
From: Shaozhong SHI <shishaozhong@gmail.com>
Sent: Thursday, February 22, 2024 9:23 AM
To: PostGIS Users Discussion <postgis-users@lists.osgeo.org>
Subject: PostGIS performance issue
My system has recently been upgraded from Linux 7 to Linux 8.
There are performance issues with PostGIS
"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."
Is possible the PostGIS not configured properly?
Regards,
David
[Attachment #3 (text/html)]
<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=utf-8"><meta name=Generator content="Microsoft Word 15 \
(filtered medium)"><style><!-- /* Font Definitions */
@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;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@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" style='word-wrap:break-word'><div class=WordSection1><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<o:p></o:p></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.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></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.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p \
class=MsoNormal>First of all?<o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></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)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p \
class=MsoNormal>SELECT version(), postgis_full_version();<o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></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.<o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p \
class=MsoNormal><o:p> </o:p></p><div style='border:none;border-left:solid blue \
1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid \
#E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b>From:</b> Shaozhong \
SHI <shishaozhong@gmail.com> <br><b>Sent:</b> Thursday, February 22, 2024 9:23 \
AM<br><b>To:</b> PostGIS Users Discussion \
<postgis-users@lists.osgeo.org><br><b>Subject:</b> PostGIS performance \
issue<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p \
class=MsoNormal><span style='font-size:12.0pt;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><o:p></o:p></p></div><div><p \
class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><span \
style='font-size:12.0pt;color:black'>Is possible the PostGIS not configured \
properly?</span><o:p></o:p></p></div><div><p \
class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><span \
style='font-size:12.0pt;color:black'>Regards,</span><o:p></o:p></p></div><div><p \
class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal \
style='margin-bottom:12.0pt'><span \
style='font-size:12.0pt;color:black'>David</span><o:p></o:p></p></div></div></div></div></body></html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic