| From: | postgann2020 s <postgann2020(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Subject: | Suggestion on table analyze |
| Date: | 2020-05-21 14:18:03 |
| Message-ID: | CANynezMbVr894sUocUkw0_nWgKeBVUn+xqaW_vL=c3OOYd1w8Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-performance |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | postgann2020 s | 2020-05-21 14:27:44 | Suggestion on index creation for TEXT data field |
| Previous Message | postgann2020 s | 2020-05-20 18:20:53 | Suggestion to improve query performance. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | postgann2020 s | 2020-05-21 14:27:44 | Suggestion on index creation for TEXT data field |
| Previous Message | Stephen Frost | 2020-05-21 12:43:03 | Re: pg_basebackup + incremental base backups |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | postgann2020 s | 2020-05-21 14:27:44 | Suggestion on index creation for TEXT data field |
| Previous Message | Pavel Stehule | 2020-05-21 12:49:57 | Re: proposal: schema variables |