Re: Documenting pglesslog

Koichi Suzuki wrote:
> Pg_readahead is a tool to prefetch data pages before redoing, based on
> the contents of archive/active WAL segment.   For 8.3 and 8.4 without
> sync.rep, this works together with restore_command.   Pg_readahead
> analyze WAL segment, schedule and issue posix_fadvise() to prefetch
> data pages quickly before redoing.
> 
> Discussions and materials will be found at
> 
> http://archives.postgresql.org/pgsql-hackers/2008-10/msg01372.php
> 
> So far, external command implemantation speeds up PITR up to six
> times!  Therefore, overall recovery time can be a little longer than
> that with FPW.

Now that 8.4 is using fsync, sounds like something that should be
integrated into the core code, rather than as a /contrib.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +