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

> 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

I would drop and recreate the index.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026