Suggestion on table analyze
От | postgann2020 s |
---|---|
Тема | Suggestion on table analyze |
Дата | |
Msg-id | CANynezMbVr894sUocUkw0_nWgKeBVUn+xqaW_vL=c3OOYd1w8Q@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Suggestion on table analyze
Re: Suggestion on table analyze Re: Suggestion on table analyze |
Список | pgsql-general |
Hi Team,
Thanks for your support.
Could you please suggest on below query.
Environment
PostgreSQL: 9.5.15
Postgis: 2.2.7
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.
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 по дате отправления: