Re: rehashing catalog cache id 14 for pg_opclass; 17 tups, 8 buckets

On 04/17/2018 01:14 PM, Thiemo Kellner wrote:
> Hi all
>
> When running following query in psql (server and client version 10 with
> replication on Debian 9), I get the message mentioned in the subject. I
> have not found much searching the internet. There were suggestions on
> bloat so I ran "vacuum (verbose, full, analyze)" but the message remains.
>

>
> I do not feel that my DB has a problem but I was taken aback a bit when
> I first saw the message in the subject.
>
> I would be grateful about a bit shed light.

What do you have your log levels set to?

The only place I can find this message is in:

src/backend/utils/cache/catcache.c

elog(DEBUG1, "rehashing catalog cache id %d for %s; %d tups, %d buckets",
cp->id, cp->cc_relname, cp->cc_ntup, cp->cc_nbuckets);

If I am following correctly it is fairly low level message.

>
> Kind regards Thiemo
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com