Re: Index creation

Helge Bahmann <bahmann@math.tu-freiberg.de> writes:
>>>> dhcp=# create index idx_fqhname on hosts using hash(hostname);
>>>> CREATE
>>>> dhcp=# vacuum analyze;
>>>> NOTICE:  Index tmp: NUMBER OF INDEX' TUPLES (61) IS NOT THE SAME AS HEAP'
>>>> (62). Recreate the index.
>>
> [snip]
>> If you see this in an otherwise-idle system, then it might be worth
>> worrying about...

> I retried, this time the system was completely idle, only one backend
> running (me). Same message. What should I do?

Oh, I hadn't noticed before that you were using a hash index.  I'll bet
there's one tuple in the table that has a NULL hostname.  Hash doesn't
index nulls ... but I don't think vacuum's count cross-check knows that.

            regards, tom lane