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: |
Description
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 .
Note:
See TracTickets
for help on using tickets.
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…
r13831