[postgis-users] Row estimations

Paul Ramsey pramsey at cleverelephant.ca
Fri Dec 9 10:14:17 PST 2022



> On Dec 9, 2022, at 10:11 AM, Igor ALBUQUERQUE SILVA <i.albuquerque-silva at kayrros.com> 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.


More information about the postgis-users mailing list