Re: Bitmap index thoughts - Mailing list pgsql-hackers

From Gavin Sherry
Subject Re: Bitmap index thoughts
Date
Msg-id Pine.LNX.4.58.0702090327120.31875@linuxworld.com.au
Whole thread Raw
In response to Re: Bitmap index thoughts  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-hackers
On Thu, 8 Feb 2007, Heikki Linnakangas wrote:

> Gavin Sherry wrote:
> > I will update the code tomorrow. The focus will be cleaning up the
> > executor modifications. Please look else where for now.
>
> I'm getting a segfault with this test script:
>
> --------
> CREATE TABLE bmtest (i int);
>
> INSERT INTO bmtest SELECT 1 FROM generate_series(1,100000) a;
> INSERT INTO bmtest SELECT 10 FROM generate_series(1,100) a;
> DELETE FROM bmtest WHERE i = 1;
> VACUUM bmtest;
>
> CREATE INDEX i_bmtest ON bmtest USING bitmap (i);
>
> INSERT INTO bmtest SELECT 10 FROM generate_series(1,100000) a;
> --------
>

Hmm... this triggers a bug in the newly rewritten update code I think.
I'll post a fix soon.

Thanks for testing!

Gavin


pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Reduce WAL activity for page splits: > Currently, an index split
Next
From: Marc Munro
Date:
Subject: Re: referential Integrity and SHARE locks