[postgis-users] Suggestion on table analyze

[Giuseppe Broccolo]

Hi PostgAnn,

This NOTICE is raised by PostGIS, while it's trying to build statistics for
geospatial attributes (columns)
of a specific relation (table) of the database, but it then realyses that
all the rows present null/empty geometries.

Check if geometries have been properly inserted in the tables, and they are
not empty geometries.

My 2 cents,
Giuseppe.

Il giorno ven 22 mag 2020 alle ore 07:52 postgann2020 s <
postgann2020 at gmail.com> ha scritto:

> Hi Team,
> Thanks for your support.
> Could you please suggest on below query.
> EnvironmentPostgreSQL: 9.5.15
> Postgis: 2.2.7
> Mostly table contain GIS data.
> While analyzing the table getting below NOTICE. It seems is pretty
> understanding, but needs help on the below points.
> 1. What might be the reason for getting the NOTICE?.
> 2. Is this lead to any problems in the future?.
>
> ANALYZE SCHEMA.TABLE;
>
> NOTICE:  no non-null/empty features, unable to compute statistics
> NOTICE:  no non-null/empty features, unable to compute statistics
> Query returned successfully with no result in 1.1 secs.
>
> Thanks for your support.
> Regards,
> PostgAnn.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200522/beb0b50c/attachment.html>