[postgis-users] Bad plan without && operator

Sandro Santilli strk at kbt.io
Thu Dec 7 08:02:37 PST 2017


On Thu, Dec 07, 2017 at 06:48:05AM -0800, Paul Ramsey wrote:
> Are you sure that's what SET STATISTICS means? I thought it was the
> size of the sample drawn to build the statistics. The histogram size
> is somewhat hardcoded,
> https://github.com/postgis/postgis/blob/svn-trunk/postgis/gserialized_estimate.c#L1446-L1453

As you can read in that comment, each side of the grid
is composed by stats->attr->attstattarget cells, so 100x100
by default and can be raised by SET STATISTICS.

You both make the grid bigger *and* the sample bigger.

--strk;


More information about the postgis-users mailing list