| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Koichi Suzuki <koichi(dot)szk(at)gmail(dot)com> |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Documenting pglesslog |
| Date: | 2009-01-14 14:35:42 |
| Message-ID: | 200901141435.n0EEZg625183@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2009-01-14 14:43:32 | Re: reloptions with a "namespace" |
| Previous Message | Daniel Verite | 2009-01-14 14:21:02 | Re: inconsistency in aliasing |