[postgis-users] estimated extent and EPSG:5514

Sandro Santilli strk at kbt.io
Mon Nov 21 08:00:52 PST 2016


On Mon, Nov 21, 2016 at 04:54:30PM +0100, Martin Landa wrote:
> Hi,
> 
> 2016-11-21 16:38 GMT+01:00 Sandro Santilli <strk at kbt.io>:
> > How many rows do you have in that table ?
> 
> count | 8
> 
> > Did you change stat targets for the column ?
> 
> No, AFAIK.
> 
> >  SELECT attstattarget
> >    FROM pg_attribute
> >   WHERE attrelid = 'ruian.kraje'::regclass
> >     AND attname = 'geom';
> 
> attstattarget | -1

show default_statistics_target; -- I guess 100 ?

The only thing I can think of is that the "hard deviant removal" phase
is considering the geom in the upper-right corner as hard-deviant, as
they are beyond the 90% of total extent. Are them points ?

--strk;


More information about the postgis-users mailing list