Re: Index creation

Helge Bahmann <bahmann(at)math(dot)tu-freiberg(dot)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