Re: [postgis-users] Suggestion on table analyze

2020-05-22 Thread postgann2020 s
Hi Giuseppe, Raúl, Thank you for the clarification. Regards, PostgAnn. On Fri, May 22, 2020 at 2:34 PM wrote: > As Giuseppe mentioned, it only means that Postgis didn't find any > geometry (or all of them were NULL or empty) when gathering > information during the analyze call. It is not an is

Re: [postgis-users] Suggestion on table analyze

2020-05-22 Thread rmrodriguez
As Giuseppe mentioned, it only means that Postgis didn't find any geometry (or all of them were NULL or empty) when gathering information during the analyze call. It is not an issue, just beware that Postgres won't have accurate data about that table in order to better plan the queries. Also, the

Re: [postgis-users] Suggestion on table analyze

2020-05-22 Thread 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 tab

[postgis-users] Suggestion on table analyze

2020-05-21 Thread postgann2020 s
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 fo