From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | Florian Weimer <fweimer(at)bfk(dot)de> |
Cc: | David Fetter <david(at)fetter(dot)org>, PG Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Page Checksums + Double Writes |
Date: | 2011-12-22 08:55:29 |
Message-ID: | CA+U5nMK96DzttA0z=PaL8jy+4bi2_6nMFzQyTOJdfW244FmQ-g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Dec 22, 2011 at 8:42 AM, Florian Weimer <fweimer(at)bfk(dot)de> wrote:
> * David Fetter:
>
>> The issue is that double writes needs a checksum to work by itself,
>> and page checksums more broadly work better when there are double
>> writes, obviating the need to have full_page_writes on.
>
> How desirable is it to disable full_page_writes? Doesn't it cut down
> recovery time significantly because it avoids read-modify-write cycles
> with a cold cache?
It's way too late in the cycle to suggest removing full page writes or
code them. We're looking to add protection, not swap out existing
ones.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Jesper Krogh | 2011-12-22 09:00:50 | Re: Page Checksums + Double Writes |
Previous Message | Simon Riggs | 2011-12-22 08:53:28 | Re: Page Checksums + Double Writes |