Index creation - Mailing list pgsql-novice

From Helge Bahmann
Subject Index creation
Date
Msg-id Pine.LNX.4.21.0012071506510.1742-100000@lothlorien.stunet2.tu-freiberg.de
Whole thread Raw
Responses Re: Index creation
List pgsql-novice
Hi,

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.

Should I be worried? I can drop the index, but every time I recreate it,
the same message.

Postgres version 7.0.2.

Helge
--
This signature is intentionally left blank.


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: running totals
Next
From:
Date:
Subject: Re: access.mdb import