Re: Child itemid in update-chain marked as unused - can't continue repair_frag - Mailing list pgsql-hackers

"V. M." <txian@hotmail.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