Josh Berkus wrote:
>> This might be worth mentioning, since it can be quite a big difference
>> in the right circumstances, and it helps a bit with the scalability
>> problem of the recovery. Should mention that it only helps with
>> full_pages_writes=on. One more reason to not gamble with data integrity
>> ;-).
>
> Does this mean that recovery from logs with full_page_writes will be faster
> than recovery from logs without them?
In general, yes. Depends a lot on how randomly the data in the WAL is
distributed, speed of reading from WAL etc.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com