This looks bad...

From: Mattias Norlander <mattias(at)umc(dot)se>
To: pgsql-admin(at)postgresql(dot)org
Subject: This looks bad...
Date: 2000-04-26 08:13:09
Message-ID: 86bt2xp9ey.fsf@marge.umc.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi!

For the last couple of months i see the following when doing my daily
vacuum:

---x---
NOTICE: Index pg_attribute_attrelid_index: NUMBER OF INDEX' TUPLES (422) IS NOT THE SAME AS HEAP' (436)
NOTICE: Index pg_attribute_relid_attnum_index: NUMBER OF INDEX' TUPLES (422) IS NOT THE SAME AS HEAP' (436)
NOTICE: Index pg_attribute_relid_attnam_index: NUMBER OF INDEX' TUPLES (422) IS NOT THE SAME AS HEAP' (436)
---x---

Seems like the indexes on a system table (pg_attribute) are
bad. Anybody else out there had the same trouble? Can this affect the
behaviour of my database? I must say that it sounds kinda bad, but as
far as I can tell the database is working as it should.

--
Mattias Norlander
mattias(at)umc(dot)se

Browse pgsql-admin by date

  From Date Subject
Next Message jsahn 2000-04-26 08:29:39 [postgresql-7.0RC1] relocation error under solaris 2.6
Previous Message leshan 2000-04-25 10:46:11 More ?'s Lightweight front end