If you're using "full page write = off", prefetching data page from
WAL speeds up the recovery too. I've proposed this patch but was
carried over to 8.5. I'm planning to release this as an external
tool, which will not work well with Hot Standby but will work in
usual recovery.
I'm not sure how soon I can do it but hope it works.
2009/4/13 Bryan Murphy <bmurphy1976@gmail.com>:
> On Sun, Apr 12, 2009 at 5:52 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
>> The database is performing too frequent restartpoints.
>>
>> This has been optimised in PostgreSQL 8.4 by the addition of the
>> bgwriter running during recovery. This will mean that your hot spare
>> will not pause while waiting for restartpoint to complete, so will be
>> significantly faster.
>
> 8.4 is already looking like it's going to be a great upgrade for us,
> this would be another win.
>
> Thanks,
> Bryan
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
------
Koichi Suzuki