Opened 10 years ago

Last modified 2 months ago

#2614 new enhancement

Prepared geometry support for ST_DWithin — at Initial Version

Reported by: robe Owned by: pramsey
Priority: high Milestone: PostGIS Fund Me
Component: postgis Version: master
Keywords: Cc:

Description

In some cases, despite what we tell people, doing an

ST_Intersects(geom1, ST_Buffer(geom2,radius)) 

is sometimes faster than ST_DWithin(geom1,geom2)

Granted ST_DWithin is faster.

I'll come up with a small self-standing example to demonstrate the point. The one I have currently is kind of hefty.

But basic assumption is if you have a fairly large constant geometry then ST_Intersects(ST_Buffer..) often out performs ST_DWithin. I assume this is because ST_Intersects takes advantage of prepared geometries and ST_DWithin does not.

Change History (0)

Note: See TracTickets for help on using tickets.