Re: [postgis-users] Row estimations

2022-12-09 Thread Paul Ramsey
> On Dec 9, 2022, at 10:11 AM, Igor ALBUQUERQUE SILVA > 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

Re: [postgis-users] Row estimations

2022-12-09 Thread Igor ALBUQUERQUE SILVA
Thanks a lot Paul and Regina! This was a very clear overview of how the estimations work, it's much clearer to me now. I've done a few more tests and what you said is true for the test case I sent before. I've experimented with larger test cases with more points and I think I found a solution for