PostGIS performance issue

[Shaozhong SHI]

product_assurance=# SELECT version(),  postgis_full_version();

version
|
postgis_full_version



----------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------
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
XML="2.9.7" LIBJSON="0.13.1" LIBPROTOBUF="1.3.0" WAGYU="0.5.0 (Internal)"


On Thu, 22 Feb 2024 at 14:38, Regina Obe <lr at pcorp.us> wrote:

> 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 at gmail.com>
> *Sent:* Thursday, February 22, 2024 9:23 AM
> *To:* PostGIS Users Discussion <postgis-users at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240318/7cb9935c/attachment.htm>