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:

[EMAIL PROTECTED]:~/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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to