Re: Release Note Changes - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Release Note Changes
Date
Msg-id 47512421.70001@enterprisedb.com
Whole thread Raw
In response to Re: Release Note Changes  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Louis-David Mitterrand
Date:
Subject: Re: 8.3beta3 ERROR: cached plan must not change result type
Next
From:
Date:
Subject: Re: Replacement Selection