> On Dec 9, 2022, at 10:11 AM, Igor ALBUQUERQUE SILVA
> <[email protected]> wrote:
>
> In this example ST_Contains estimates 785 rows, while ST_Intersect estimates
> 615469 which is closer to the real 621571 rows. Using the bounding box
> operation I also obtain good estimations, and I also obtain good estimations
> if I don't use the gist index.
>
This still seems Really Bad (tm) in that the contains estimate is still
tragically wrong. However, we have at least some clue as to where to hunt for
this bug. Thanks for continuing to push the testing forward.
P.
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users