This looks bad... - Mailing list pgsql-admin

From Mattias Norlander
Subject This looks bad...
Date
Msg-id 86bt2xp9ey.fsf@marge.umc.se
Whole thread Raw
List 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@umc.se

pgsql-admin by date:

Previous
From: leshan@ugsolutions.com
Date:
Subject: More ?'s Lightweight front end
Next
From: jsahn@samsung.co.kr
Date:
Subject: [postgresql-7.0RC1] relocation error under solaris 2.6