Ron Mayer <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> If you have to hit one tuple out of four, it's pretty much guaranteed >> that you will need to fetch every heap page.
> I think it's not uncommon to have data that is more clustered than expected. Sure, if the data is fairly static ... and now that there's a fillfactor option for heaps, you can even tolerate (some low rate of) updates without losing the clusteredness. However, that benefit accrues to all index types not only bitmap. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings