| 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-27 11:33:20 |
| Message-ID: | 45925A00.1040403@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Gavin Sherry wrote:
> There are still some things Jie and I have not gotten to yet:
> ...
> o Test WAL replay more thoroughly.
Found one WAL related bug:
postgres=# CREATE TABLE test (i int);
CREATE TABLE
postgres=# INSERT INTO test SELECT a FROM generate_series(1,10) a;
INSERT 0 10
postgres=# CREATE INDEX mdx ON test USING bitmap(i);
CREATE INDEX
postgres=# INSERT INTO test VALUES (11);
INSERT 0 1
postgres=# \q
killall -9 postgres, and restart. Redo fails with:
PANIC: bm_insert_redo: LOV item is not inserted in pos 2(requested 12)
CONTEXT: xlog redo insert a new LOV item: rel 1663/10817/16388
I haven't dug deeper yet.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin Sherry | 2006-12-27 13:05:40 | Re: On-disk bitmap index implementation |
| Previous Message | Dhanaraj M | 2006-12-27 10:02:51 | Allow the identifier length to be increased via a configure option |