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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend