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-27 13:05:40 |
Message-ID: | Pine.LNX.4.58.0612280004530.24765@linuxworld.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
On Wed, 27 Dec 2006, Heikki Linnakangas wrote:
> 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.
Yes, there were a bunch of WAL issues we wanted to address. Jie has been
working on this too. Thanks for the feedback, we can use this as a test.
Thanks,
Gavin
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-12-27 14:28:25 | Re: [HACKERS] Patch(es) to expose n_live_tuples and |
Previous Message | Heikki Linnakangas | 2006-12-27 11:33:20 | Re: On-disk bitmap index implementation |