Re: Commercial postgresql

On 2 Sep 2003 at 9:36, Vivek Khera wrote:

> >>>>> "BL" == Bo Lorentsen <bl(at)netgroup(dot)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.