[postgis-tickets] [PostGIS] #5547: postgis 3.4 not using gist index when concatinating string in st_geomfromtext

PostGIS trac at osgeo.org
Fri Sep 22 08:25:23 PDT 2023


#5547: postgis 3.4 not using gist index when concatinating string in
st_geomfromtext
-----------------------+---------------------------
  Reporter:  tomwlane  |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 3.4.1
 Component:  postgis   |    Version:  3.4.x
Resolution:            |   Keywords:
-----------------------+---------------------------
Comment (by tomwlane):

 I did update postgresql at the same time so the one thats failing is 15
 and postgis 3 and it worked when i was running 11 and postgis 2,

 I don't currently have a way to test 11 and 3, but I may while I'm
 upgrading the prod servers, I'll plan to try

 failing
 PostgreSQL 15.3, compiled by Visual C++ build 1914, 64-bit |
 POSTGIS="3.4.0 3.4.0" [EXTENSION] PGSQL="110" (procs need upgrade for use
 with PostgreSQL "150") GEOS="3.12.0-CAPI-1.18.0" PROJ="8.2.1
 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org
 USER_WRITABLE_DIRECTORY=C:\WINDOWS\ServiceProfiles\NetworkService\AppData\Local/proj
 DATABASE_PATH=C:\Program
 Files\PostgreSQL\15\share\contrib\postgis-3.4\proj\proj.db" GDAL="GDAL
 3.7.1, released 2023/07/06" LIBXML="2.9.14" LIBJSON="0.12"
 LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)" (core procs from "3.3.3
 3.3.3" need upgrade) RASTER (raster procs from "3.3.3 3.3.3" need upgrade)

 working
 PostgreSQL 11.18, compiled by Visual C++ build 1914, 64-bit |
 POSTGIS="2.5.3 r17699" PGSQL="100" (procs need upgrade for use with "110")
 GEOS="3.7.2-CAPI-1.11.0 3.7.2" PROJ="Rel. 4.9.3, 15 August 2016"
 GDAL="GDAL 2.2.4, released 2018/03/19" LIBXML="2.7.8" LIBJSON="0.12"
 LIBPROTOBUF="1.2.1" (core procs from "2.4.4 r16526" need upgrade) RASTER
 (raster procs from "2.4.4 r16526" need upgrade)
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5547#comment:2>
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