Re: Index creation

On Thu, 7 Dec 2000, Tom Lane wrote:

> Helge Bahmann <bahmann@math.tu-freiberg.de> writes:
> > I got a strange messange wrt indexes today:
>
> > 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?

Sidenote: I have several other indices on the table which appear to be
unaffected.

Thanks for you quick reply,
Helge
--
This signature is intentionally left blank.