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

Re: On-disk bitmap index implementation

From: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org, Jie Zhang <jzhang(at)greenplum(dot)com>
Subject: Re: On-disk bitmap index implementation
Date: 2006-12-06 05:05:11
Message-ID: Pine.LNX.4.58.0612061604350.3279@linuxworld.com.au (view raw or flat)
Thread:
Lists: pgsql-patches
On Tue, 5 Dec 2006, Heikki Linnakangas wrote:

> 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)

Oops :-).

Thanks for pointing it out. I think I might have busted something merging
with HEAD. Don't you hate that?

Thanks,

Gavin

In response to

pgsql-patches by date

Next:From: Bruce MomjianDate: 2006-12-06 15:46:02
Subject: Re: FAQ refresh
Previous:From: Simon RiggsDate: 2006-12-06 00:54:05
Subject: Re: [HACKERS] Configuring BLCKSZ and XLOGSEGSZ (in 8.3)

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