[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