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-05 01:52:01
Message-ID: Pine.LNX.4.58.0612051250360.24982@linuxworld.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

On Mon, 4 Dec 2006, Heikki Linnakangas wrote:

> > o Test WAL replay more thoroughly.
>
> I've had that problem too with a lot of things I've hacked. I've used a
> shell script that does the operation under test, runs a select, kills
> and restarts postmaster, and reruns the select. If the select after
> crash returns the same result as before, presumably WAL code works. But
> you need to watch out for full page writes that might mask bugs in the
> redo code.
>
> Anyone have a more sophisticated method?

Well, I've done a combination of what you did and replaying a bunch of
operations using PITR.

Thanks,

Gavin

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Iannsp 2006-12-05 02:05:36 Re: [DOCS] 8.2.0 pdf
Previous Message Gavin Sherry 2006-12-05 00:10:42 Re: On-disk bitmap index implementation