Skip site navigation (1) Skip section navigation (2)

Re: On-disk bitmap index implementation

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 (view raw or flat)
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

In response to

Responses

pgsql-patches by date

Next:From: Filip RembiaƂkowskiDate: 2006-12-05 17:07:41
Subject: typo in contrib/hstore/hstore_io.c
Previous:From: Tom LaneDate: 2006-12-05 16:25:20
Subject: Re: FAQ refresh

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group