Re: Thoughts on maintaining 7.3 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Thoughts on maintaining 7.3
Date
Msg-id 10268.1065047755@sss.pgh.pa.us
Whole thread Raw
In response to Re: Thoughts on maintaining 7.3  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
"Joshua D. Drake" <jd@commandprompt.com> writes:
>    When I was reading hackers about the fixes you had made, it stated 
> that the index bloat problems should be better. I took
> that as meaning that although it won't be required nearly as often, we 
> still may need to reindex occassionaly.

The critical word there is "may".  The index compression code covers
some cases and not others.  Depending on your usage pattern you might or
might not ever need to reindex.  I *think* that most people won't need
to reindex any more, but I'm waiting on field reports from 7.4 to find
out for sure.

In any case, people who aren't upgrading from 7.3 because they think
7.4 won't help them are making a self-fulfilling negative prophecy.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: updating INSTALL file
Next
From: Tom Lane
Date:
Subject: Re: ADD FOREIGN KEY