> 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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster