| From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Subject: | Re: Release Note Changes |
| Date: | 2007-12-01 09:06:41 |
| Message-ID: | 47512421.70001@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mac_man2005 | 2007-12-01 09:38:08 | Re: Replacement Selection |
| Previous Message | Louis-David Mitterrand | 2007-12-01 08:28:59 | Re: 8.3beta3 ERROR: cached plan must not change result type |