Suggestion on table analyze

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: Raw Message | Whole Thread | 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.

Responses

Browse pgsql-admin by date

  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.

Browse pgsql-general by date

  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

Browse pgsql-performance by date

  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