Postgres Pro
Downloads
Home   >   mailing lists

WARNING: skipping "pg_database" --- only superuser can analyze it - Mailing list pgsql-general

From Abraham, Danny
Subject WARNING: skipping "pg_database" --- only superuser can analyze it
Date
Msg-id PH0PR02MB7446AD39A0B48692D996E4EC8E039@PH0PR02MB7446.namprd02.prod.outlook.com
Whole thread Raw
Responses Re: WARNING: skipping "pg_database" --- only superuser can analyze it  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Yu Watanabe
Date:
Subject: Memory activities to monitor in statistics collector?
Next
From: Tom Lane
Date:
Subject: Re: schema prefixes in default values (was RE: removing "serial" from table definitions).