[postgis-tickets] [PostGIS] #5186: PostGIS performance regressions on identical queries

PostGIS trac at osgeo.org
Wed Jul 20 11:24:35 PDT 2022


#5186: PostGIS performance regressions on identical queries
----------------------+---------------------------
  Reporter:  dracos   |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.2.2
 Component:  postgis  |    Version:  3.1.x
Resolution:           |   Keywords:
----------------------+---------------------------
Comment (by robe):

 Replying to [comment:3 dracos]:
 > Hi robe, thanks for looking. I do still have the old. Swapping the order
 round gives the same query plan and execution time on both 9.6 and 13. If
 I leave out the explicit index part, then on PostgreSQL 13 it makes no
 difference (as you'd hope), but on PostgreSQL 9.6 it makes the query take
 many minutes to run, because it doesn't use the index automatically.

 So execution time, with && and ST_CoveredBy (does that make the 13 faster
 or the 9.6 slower?)
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5186#comment:4>
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