On Tue, 2008-10-28 at 16:33 +0900, Koichi Suzuki wrote:
> This is my first proposal of PITR performance improvement for
> PostgreSQL 8.4 development. This proposal includes readahead
> mechanism of data pages which will be read by redo() routines in the
> recovery. This is especially effective in the recovery without full
> page write. Readahead is done by posix_fadvise() as proposed in
> index scan improvement.
>
> Details of the implementation will be found in README file in the material.
I'm happy with the idea of a readahead process. I thought we were
implementing a BackgroundReader process for other uses. Is that dead
now?
I see you're doing this as a standalone command. Shame we can't include
this into core for now, but I can see the reasons why.
How does the whole toolchain look with this?
Can you give a simple example of using pg_lesslog, pg_readahead and
pg_standby together, if that is appropriate?
-- Simon Riggs www.2ndQuadrant.comPostgreSQL Training, Services and Support