[Bizgres-general] Cutover to 8.1.3 merge in progress

[Mark Kirkwood]

Luke Lonergan wrote:
> Mark,
> 
> On 3/6/06 2:01 PM, "Mark Kirkwood" <markir at paradise.net.nz> wrote:
> 
>>I suspect the retrieval time is being mainly spent in heap fetches, so
>>index access (bitmap or btree) is not the bottleneck (I can hear someone
>>muttering about how good index-only access would be....).
> 
> 
> Yep!  There's some other bits at work here too - Jie is continuing to work
> on the problem with Ayush.
>  
> The reason we've put this out there is that it is a big improvement in space
> and time on the creation side, and doesn't hurt query performance.  

Indeed - it looks pretty good!

> In cases
> where a BTREE index does not fit in RAM, this could also have a big positive
> performance enhancement on the query side.
> 

I think so too - if I have some time I'll see if I can demonstrate it 
(running TPC-H with scale 100 should do).

Cheers

Mark