"Joshua D. Drake" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
