[postgis-users] Substantial different index use between 9.5 and 9.6 using Postgis

[Bill Measday]

Thanks Regina - nice to know it wasn't just my incompetence!.

Good luck tracking down the root cause.


Rgds


Bill



On 4/12/2016 6:53 AM, Regina Obe wrote:
>
> For reference I have ticketed this as:
>
> https://trac.osgeo.org/postgis/ticket/3675
>
> ---------- message ----------
>
>
>
> Bill,
>
> Never mind. Thanks to Brian Hamlin's nudging on IRC that he sees the issue
> too, I was able to replicate it.
>
>
> I think the reason I missed it in my testing is that it doesn't happen 
> with
> the more common cases of:
>
> SELECT e.gid
> FROM e1 , e2
> WHERE ST_Intersects(e1.geom, e2.geom);
>
> Or where you use constants in ST_MakePoint like your example
>
>
> But only in case where you have:
>
> SELECT e.gid
> FROM e1 , e2
> WHERE ST_Intersects(e1.geom, ST_SetSRID(ST_MakePoint(e2.longitude,
> e2.latitude),4326)  );
>
>
> So I'll go ahead and ticket it and try to track down the root cause.  I
> suspect it affects all our relation functions.
>
> Thanks for bringing to our attention,
>
> Regina
> http://www.postgis.us
> http://postgis.net
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20161204/157ddb00/attachment.html>