[Bizgres-general] Cutover to 8.1.3 merge in progress

[Luke Lonergan]

Mark,

On 3/6/06 2:01 PM, "Mark Kirkwood" <markir at paradise.net.nz> wrote:

> I redid the TCP-H tests comparing Bizgres current (8.1.3 codebase) to
> vanilla 8.1.3 (see below):
> 
> The details for the queries etc are in previous postings.
> 
> The results are looking pretty amazing(!) for index creation time and
> size, retrieval time however looks pretty similar.

This is consistent with our tests so far - though there are some cases where
the bitmap index results are faster (but not TPC-H).
 
> 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.  In cases
where a BTREE index does not fit in RAM, this could also have a big positive
performance enhancement on the query side.

More to come...

- Luke