Opened 10 years ago

Closed 9 years ago

#2896 closed defect (fixed)

geography: increase cost of _ST_Expand and _ST_DWithin

Reported by: robe Owned by: pramsey
Priority: medium Milestone: PostGIS 2.2.0
Component: postgis Version: 2.1.x
Keywords: Cc:


Right now ST_Expand has a cost of 1 and ST_DWithin has a cost of 100. We should probably increase the cost of ST_Expand to at least 100 (and I'd up ST_Dwithin) a smidgen like maybe 150.

Although I haven't seen it in the field - perhaps because I haven't been looking, but I think the same issue with geography index possibly not being used under some circumstances would happen similar to the #2895 case .

Change History (1)

comment:1 by pramsey, 9 years ago

Resolution: fixed
Status: newclosed

expand really is cheap, at least compared to all the other COST 100 functions in geography, which are massively expensive… what's the issue this might solve? I've pumped expand up to 50, so it's not considered so very cheap, but making it the same as the other 100s makes no sense to me…


Note: See TracTickets for help on using tickets.