| From: | "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> |
|---|---|
| To: | "Gavin Sherry" <swm(at)linuxworld(dot)com(dot)au> |
| Cc: | <pgsql-patches(at)postgresql(dot)org>, "Jie Zhang" <jzhang(at)greenplum(dot)com> |
| Subject: | Re: On-disk bitmap index implementation |
| Date: | 2006-12-05 16:36:44 |
| Message-ID: | 4575A01C.5060600@enterprisedb.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Gavin Sherry wrote:
> o Improving VACUUM support -- currently, VACUUM FULL means REINDEX for
> bitmaps. Heikki Linnakangas offered to work on this. Heikki, are you
> still interested?
BTW vacuuming seems quite broken as it is:
hlinnaka(at)heikkilaptop:~/pgsql.bitmap$ ~/pgsql.bitmap/bin/psql -a
postgres < vacuumtest.sql
drop table if exists test;
DROP TABLE
create table test (key int);
CREATE TABLE
create index test_bm on test using bitmap (key);
CREATE INDEX
insert into test values (1);
INSERT 0 1
delete from test;
DELETE 1
vacuum test;
VACUUM
insert into test values (2);
INSERT 0 1
select * from test where key = 1;
key
-----
2
(1 row)
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Filip Rembiałkowski | 2006-12-05 17:07:41 | typo in contrib/hstore/hstore_io.c |
| Previous Message | Tom Lane | 2006-12-05 16:25:20 | Re: FAQ refresh |