WARNING: skipping "pg_database" --- only superuser can analyze it

From: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Cc: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Subject: WARNING: skipping "pg_database" --- only superuser can analyze it
Date: 2021-06-28 13:26:25
Message-ID: PH0PR02MB7446AD39A0B48692D996E4EC8E039@PH0PR02MB7446.namprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Good old "analyze;" will run smoothly on 11.5...
But on 12.6 will skip and warn on any pg_catalog/information_schema table.

Pg_catalog is on Usage only on both databases (11.5 and 12.6).

Questions: 1. Has the behavior changed in 12.6? 2.How can I analyze on public tables (No syntax like analyze schema=public)

Thanks

Danny

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-06-28 13:34:46 Re: schema prefixes in default values (was RE: removing "serial" from table definitions).
Previous Message Yu Watanabe 2021-06-28 11:41:07 Memory activities to monitor in statistics collector?