Re: Bitmap index status

From: Mark Wong <markw(at)osdl(dot)org>
To: Jie Zhang <jzhang(at)greenplum(dot)com>
Cc: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, swm(at)linuxworld(dot)com(dot)au, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bitmap index status
Date: 2006-09-22 22:45:28
Message-ID: 45146788.50608@osdl.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jie Zhang wrote:
> Hi Heikki and all,
>
> I just sent the latest bitmap index patch to the list. I am not sure if
> there is any size limit for this mailing list. If you have received my
> previous email, please let me know.

Hi Jie,

I know I said I was going to get testing on this months ago but I've
been juggling between 3 systems due to disk failures and other hardware
configuration issues. Anyways, I've take a baseline run of only the
power test using a 1GB database with the patch 09-17 patch against a
snapshot of pgsql from 2006-09-17:

http://dbt.osdl.org/dbt/dbt3testing/results/dev8-007/2/

Do you think the 1GB scale factor will be sufficient for testing as it
will certainly be faster? Do you think testing with just a power test
will be sufficient for now? I really don't have a good reason why I
didn't run a throughput test other than to save time. :) I also wanted
to get your opinion again on which indexes we will want to try first.

Thanks,
Mark

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-09-22 22:45:40 Traveling to Oxford, England
Previous Message Tom Lane 2006-09-22 21:52:55 Re: advisory locks and permissions