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

2016-06-05 Thread Tom Lane
Claudio Freire 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

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

2016-06-05 Thread Jeff Janes
On Sun, Jun 5, 2016 at 9:03 AM, Tom Lane wrote: > Claudio Freire 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