[postgis-tickets] [PostGIS] #5335: Specific query hangs and can't be terminated when using ST_MVT/ST_AsMVTGeom
PostGIS
trac at osgeo.org
Wed Feb 8 13:51:07 PST 2023
#5335: Specific query hangs and can't be terminated when using ST_MVT/ST_AsMVTGeom
----------------------+--------------------------------
Reporter: seabre | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS PostgreSQL
Component: postgis | Version: 2.5.x
Resolution: | Keywords:
----------------------+--------------------------------
Comment (by robe):
GEOS 3.6 and PostGIS 2.5 have been End-of-lifed and not only are those end
of lifed, but you are running very old versions of those too. While
PostgreSQL 11 is not EOL'd, you are running a very old micro which
probably has a ton of bugs in it that have already been fixed. Latest
match release for PostgreSQL 11 is 11.18.
Any chance you can upgrade to newer versions and test. At the very least
newer micros of GEOS 3.6 (GEOS 3.6.5 or higher) and PostGIS 2.5 (2.5.7 or
higher)
https://postgis.net/2022/11/12/postgis-2.5.9-eol/
I think we've had several mvt issues we've fixed since your 2.5.2/3.6.2
so next to impossible to tell if this is still an issue without some data
that exercises it.
If you can provide some data, we can at least test on newer versions and
tell you if upgrading would help.
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5335#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list