Skip site navigation (1) Skip section navigation (2)

Index creation

From: Helge Bahmann <bahmann(at)math(dot)tu-freiberg(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Index creation
Date: 2000-12-07 14:13:59
Message-ID: Pine.LNX.4.21.0012071506510.1742-100000@lothlorien.stunet2.tu-freiberg.de (view raw or flat)
Thread:
Lists: 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.


Responses

pgsql-novice by date

Next:From: davidbDate: 2000-12-07 15:27:49
Subject: Re: access.mdb import
Previous:From: Paul Joseph McGeeDate: 2000-12-07 11:09:47
Subject: gmake install error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group