[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