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 <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
