[postgis-tickets] [PostGIS] #4732: long planning time

[PostGIS]

#4732: long planning time
-------------------------+---------------------------
 Reporter:  michal       |      Owner:  pramsey
     Type:  enhancement  |     Status:  new
 Priority:  low          |  Milestone:  PostGIS 3.1.0
Component:  postgis      |    Version:  3.0.x
 Keywords:               |
-------------------------+---------------------------
 I have table with geography column way. I filter rows within approximately
 300metre radius from a point. I have two options:
 `where way && st_buffer
 ('0101000020E61000008E18E2FD5D8036406DD0F29771854840'::geography, 300)`
 vs.
 `where st_dwithin(way
 ,'0101000020E61000008E18E2FD5D8036406DD0F29771854840'::geography, 300)`

 both use indexes, both have more-less similar results, both have very
 short execution time. however the first one has extremely long planning
 time (40ms vs 1ms on low RAM server, 8ms vs 0.5ms on high RAM server).

 what could be the issue? can the planning time be reduced?

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4732>
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.