On 2 Sep 2003 at 9:36, Vivek Khera wrote:
> >>>>> "BL" == Bo Lorentsen <bl@netgroup.dk> writes:
>
> BL> On Tue, 2003-09-02 at 04:08, Vivek Khera wrote:
> >> 3) Index bloat is apparently a bigger problem than I thought.
> BL> This does not sound too nice !
>
> No, like I said, I shaved 900Mb of index table size this weekend by
> re-indexing. Unfortunately it meant I was partially down for about 45
> minutes per index on my largest table, and about 15 per index on the
> second largest table, and 5 per index on the third largest, then about
> 90 seconds total for the rest of the tables ;-)
Umm.. Since you have only 2.7GB of data, all inclusive, would it be real
downtime if you reindex in a transaction, assuming the "downtime" was not due
to crunch of IO bandwidth..
Just a thought..
Bye
Shridhar
--
Beauty: What's in your eye when you have a bee in your hand.