Re: index fragmentation on insert-only table with non-unique column

Claudio Freire <klaussfreire@gmail.com> writes:
> So correlated index scans look extra favourable vs bitmap index scans
> because bitmap heap scans consider random page costs sans correlation
> effects (even though correlation applies to bitmap heap scans as
> well).

Really?  How?  The index ordering has nothing to do with the order in
which heap tuples will be visited.

            regards, tom lane