[postgis-users] Row estimations

Sandro Santilli strk at kbt.io
Thu Dec 15 01:03:35 PST 2022

On Tue, Dec 13, 2022 at 11:31:05AM -0800, Paul Ramsey wrote:
> Just to put a nail in this one: the last time our selectivity estimates for Contains/Within were good was version 2.1, which used the && operator instead of hte ~/@ operators in the SQL wrapper functions.

I think I was the one chaing from && to ~/@ as they are more correct.
If we're going to change the selectivity estimator we should consider
using a different name to estimate the different filters, just in case
we'll use different implementation for one or the other. For points
they are really equal but for polygons estimates could be very
different for intersect and full containment (polygons could only
touch or have small overlap but very never be nested).


More information about the postgis-users mailing list