[postgis-users] estimated extent and EPSG:5514

Sandro Santilli strk at kbt.io
Mon Nov 21 08:11:23 PST 2016


On Mon, Nov 21, 2016 at 05:06:25PM +0100, Martin Landa wrote:
> Hi,
> 
> 2016-11-21 17:00 GMT+01:00 Sandro Santilli <strk at kbt.io>:
> > show default_statistics_target; -- I guess 100 ?
> 
> default_statistics_target | 50

Try setting them to 100, which is the default.
Then ANALYZE again, and re-run

 select _postgis_stats( 'ruian.kraje', 'geom');

Paul: the "histogram_cell:1" seems to be bogus in the code in any
case, as it looks it's always set to "1", used as a flag rather than
as an actual grid size ?

--strk;


More information about the postgis-users mailing list