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

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 по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: pg_basebackup + incremental base backups
Следующее
От: Rory Campbell-Lange
Дата:
Сообщение: Strategy for materialisation and centralisation of data