Suggestion on table analyze - Mailing list pgsql-general

From postgann2020 s
Subject Suggestion on table analyze
Date
Msg-id CANynezMbVr894sUocUkw0_nWgKeBVUn+xqaW_vL=c3OOYd1w8Q@mail.gmail.com
Whole thread Raw
Responses Re: Suggestion on table analyze
Re: Suggestion on table analyze
Re: Suggestion on table analyze
List pgsql-general
Hi Team,

Thanks for your support.

Could you please suggest on below query.

Environment
PostgreSQL: 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.

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: pg_basebackup + incremental base backups
Next
From: Rory Campbell-Lange
Date:
Subject: Strategy for materialisation and centralisation of data