[GENERAL] does vacuum rebuild index?

2000-06-12 Thread mikeo
hi, we have a 34 million row table. after many inserts, updates, deletes the performance degraded so we vacuumed the table. the output indicated that the index was also vacuumed but the size didn't change. it was still 80m so we dropped and recreated it reducing it to 20m. no big deal but

Re: [GENERAL] does vacuum rebuild index?

2000-06-12 Thread Tom Lane
mikeo [EMAIL PROTECTED] writes: we have a 34 million row table. after many inserts, updates, deletes the performance degraded so we vacuumed the table. the output indicated that the index was also vacuumed but the size didn't change. it was still 80m so we dropped and recreated it