Thread: This looks bad...

This looks bad...

From
Mattias Norlander
Date:
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