Re: Bitmap index thoughts - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Bitmap index thoughts
Date
Msg-id 45CB4666.6090404@enterprisedb.com
Whole thread Raw
In response to Re: Bitmap index thoughts  (Gavin Sherry <swm@alcove.com.au>)
Responses Re: Bitmap index thoughts  (Gavin Sherry <swm@alcove.com.au>)
Re: Bitmap index thoughts (another segfault)  (Mark Kirkwood <markir@paradise.net.nz>)
List pgsql-hackers
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;
--------


--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: HOT for PostgreSQL 8.3
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Reduce WAL activity for page splits: > Currently, an index split