From: | Helge Bahmann <bahmann(at)math(dot)tu-freiberg(dot)de> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Index creation |
Date: | 2000-12-07 17:15:29 |
Message-ID: | Pine.LNX.4.21.0012071756390.2116-100000@lothlorien.stunet2.tu-freiberg.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Thu, 7 Dec 2000, Tom Lane wrote:
> Helge Bahmann <bahmann(at)math(dot)tu-freiberg(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-12-07 17:52:07 | Re: Index creation |
Previous Message | Jody Weissmann | 2000-12-07 17:01:44 | processing results from INTERSECT, UNION or EXCEPT |