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
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