[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