| From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
|---|---|
| To: | Gavin Sherry <swm(at)alcove(dot)com(dot)au> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Bitmap index thoughts |
| Date: | 2007-02-08 15:48:54 |
| Message-ID: | 45CB4666.6090404@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Kaltenbrunner | 2007-02-08 16:11:23 | Re: Re: [COMMITTERS] pgsql: Reduce WAL activity for page splits: > Currently, an index split |
| Previous Message | Bruce Momjian | 2007-02-08 15:32:11 | pgsql: Add lock matrix to documentation. |