[postgis-users] Help with ST_CLIP

Paul Norman penorman at mac.com
Fri Mar 12 20:19:36 PST 2021

On 2021-03-12 5:53 p.m., Simon SPDBA Greener wrote:
>> 2) Also you should only be returning the part that intersects.  You 
>> are missing a WHERE clause unless you have just one raser tile, but 
>> still good to have a WHERE anyway as a precaution.  You'll know 
>> immediately if you get no rows they don't even intersect.
>> You can speed up the intersect check by adding a functional index 
>> geometry(geog) to your geography table
> How long have functional indexes been supported? 

Functional indexes have been supported since PostgreSQL 7.4.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210312/3e03726e/attachment.html>

More information about the postgis-users mailing list