"V. M." <txian(at)hotmail(dot)com> writes:
> lindo=# vacuum analyze;
> NOTICE: Index probably_good_banner_myidx1: NUMBER OF INDEX' TUPLES (1) IS
> NOT THE SAME AS HEAP' (4).
> Recreate the index.
> NOTICE: Index probably_good_banner_myidx1: NUMBER OF INDEX' TUPLES (1) IS
> NOT THE SAME AS HEAP' (4).
> Recreate the index.
> NOTICE: Child itemid in update-chain marked as unused - can't continue
> repair_frag
> VACUUM
Interesting --- can you show us the sequence that got you into this
state? A reproducible case that causes these messages would be very
useful for debugging.
> what i must do here?
Dumping and reloading the table should fix it, if nothing else does.
BTW, what Postgres version is this?
regards, tom lane